in an adjacent cell
="623"&A1

copy down, select the second column, copy to the clipboard
goto menu EditPasteSpecial, 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)

wrote in message
ups.com...
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