Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
adding text | Excel Discussion (Misc queries) | |||
Adding text to equal text | Excel Discussion (Misc queries) | |||
Adding Dashes in front of text using text formating | Excel Discussion (Misc queries) | |||
adding text | New Users to Excel | |||
Adding text | Excel Worksheet Functions |