View original (French)

Add 2 letters to numbers in Excel

Solved
gigaisa -  
 num2amel -
Hello,

I would like to add the letters JE in front of numbers that do not follow each other in a column; for example: JE184055 THEN JE185066, I have a total of 8116 different references and I need to add the two letters JE in front of each of these references; I would like to know if there is an automation or if I have to do everything manually;
thank you for your help;

Configuration: Windows XP / Internet Explorer 7.0

3 answers

  1.
    Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    Hello
    to keep it simple
    your column of numbers in A
    in B1 the formula:
    ="JE"&A1
    drag it down to the desired height
    copy the column and paste it as values in column A
    delete column B
    best regards

    Let’s ask ourselves if we are not the only ones who understand what we are explaining?
    50
    1. gigaisa
       
      Wow, thank you very much!

      Best regards.
      0
    2. marihel
       
      Thank you very much.
      0