Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Text
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Text
In a helper column say B
="DR " & A1 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Text
in a blank column, =prefix&first cell
so, assume the prefix is Mr ="Mr"&A2 copy down and across Highlight your results and copy, then paste special/values "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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Text
First change the xx in the following macro to your prefix.
Then select the cells you want to modify Then run the macro Sub prefixx() For Each r In Selection r.Value = "xx" & r.Value Next End Sub -- Gary''s Student - gsnu200806 "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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |