Thread: Adding Text
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Adding Text

If the names are in column A, then you can use a formula like this in
a helper column:

="xy"&A1

and copy this down as required. Then you can fix the values in the
helper column by highlighting all the cells with the formula in,
clicking <copy, then Edit | Paste Special | Values (check) | OK then
<Esc. Then you can copy/paste these over the originals in column A
and then delete the helper column.

Hope this helps.

Pete

On Oct 10, 6:24*pm, Brent wrote:
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?