Thread: Adding Text
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom[_2_] Peo Sjoblom[_2_] is offline
external usenet poster
 
Posts: 964
Default Adding Text

Assume the names are in column A starting in A2, make sure column B is empty
or insert a new column B,
in B2 put


="XY"&A2

or if you want a space between


="XY"&" "&A2


replace XY with your prefix

and copy down as long as needed. Then select the help column, copy it, paste
special as values over the old
and delete the help column

--


Regards,


Peo Sjoblom

"Brent" wrote in message
...
I have a whole page of different names and I need to add the same two
letter
prefix to the beginning of each of them?