Adding digits

P

pjamorton

Hello! In a cell, I have "AME 013". I want to insert "623" to the
beginning of that cell, so the result will look like "623AME 013". How
do I go about doing this? Obviously I have a ton of them to do
otherwise I would just type it in! Thanks in advance! Jen
 
P

Pete_UK

Assuming your "AME 013" is in cell A1, enter this formula in a helper
column:

="623"&A1

and copy the formula down for as many entries as you have in column A.

You can fix the values if you want using Paste Special.

Hope this helps.

Pete
 
B

Bob Phillips

in an adjacent cell
="623"&A1

copy down, select the second column, copy to the clipboard
goto menu Edit>PasteSpecial, click the Value button, OK out

delete the original column.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Top