View original (French)

Insert a number in Excel cells

Solved
El Prezz Posted messages 13 Status Member -  
 Mediak -
Hello,

I have a phone list with about 500 abbreviated numbers (so 500 lines) and I need to insert a "3" in front of each number.

Not really good at this and not keen on adding that famous "3" in each cell, can you help me???

Thanks in advanceConfiguration: Windows XP Internet Explorer 6.0

2 answers

  1.
    UsulArrakis Posted messages 7683 Status Contributor 3 196
     
    Hello
    insert an empty column (example B)
    if your first number is in A2
    put the formula in B2 ="3"&A2 or =CONCATENATE("3";B2)
    and copy down
    --

    (_Usul of Arrakis
        Serial_Dreamer_)
    19
    1. Black4Mamba Posted messages 328 Status Member 60
       
      Problem solved
      After that, you select all the boxes with your numbers with the 3 in front, you copy them, go to another cell, and do a special paste: values.

      You can then delete the unnecessary cells.
      4
    2. El Prezz Posted messages 13 Status Member 2
       
      Thank you very much for your responsiveness and your expertise, Usul of Arrakis.

      Problem solved

      Great class

      Thank you
      2
      1. KHADIJAHIMI > El Prezz Posted messages 13 Status Member
         
        thank you for the formula
        0
    3. Mediak
       
      Thank you for this long-standing help, which is still useful today.
      0