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 answers

  1.
    SCARL Posted messages 13 Status Member 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
    1. 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
    2. lagrandepat
       
      Great, it's working perfectly :)
      0
    3. bvw
       
      10 years later, it still works. Thank you.
      0