View original (French)

Insert a number in Excel cells

Solved
El Prezz Posted messages 13 Status Membre -  
 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 réponses

Réponse 1 / 2
UsulArrakis Posted messages 7683 Status Contributeur 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
Black4Mamba Posted messages 328 Status Membre 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
El Prezz Posted messages 13 Status Membre 2
 
Thank you very much for your responsiveness and your expertise, Usul of Arrakis.

Problem solved

Great class

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