View original (French)

Extract a piece from a cell in Excel

Solved
nicoatlante -  
 bvw -
Hello everyone,

I am reaching out to your expertise because I have the following problem:

I have a file with 3 columns. The 1st is a complete descriptive list of my products.
The 2nd is a condensed list.
And I would like to extract part of the information from the 1st column into the 3rd column.

As explained in the attached file.
http://www.cijoint.fr/cjlink.php?file=cj201012/cijVBmyMwa.xls

Does anyone have the solution?

Thank you in advance.

Best regards,

Configuration: Windows XP / Firefox 3.6.13

4 réponses

Réponse 1 / 4
SCARL Posted messages 13 Status Membre 52
 
Hello nicoatlante,
I just opened your Excel file and read your message,
actually in column C titled Internal No., you enter the formula =MID(A2,7,6), which extracts the 6 digits following the 7th character of cell A2, then copy the formula down to the other cells
I hope this answers your question.
76
nicoatlante
 
Awesome,

Thank you very much, everyone.
It works like a charm.

I might need you again in a few minutes for a research question, if that's alright.

Thanks again, and maybe see you soon.
0
lagrandepat
 
Great, it's working perfectly :)
0
bvw
 
10 years later, it still works. Thank you.
0