Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
re-arrange text
How can i re-arrange a list of text (which are names) in such a way: for
example changing Bob Smith to: Smith, Bob. is there an easier way of doing it than manually so that i can apply it to a large list? Thanks! Gem |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
re-arrange text
Assuming your list in column A, put this in B1 and copy down........
=MID(A1,FIND(" ",A1,1),99)&", "&LEFT(A1,FIND(" ",A1,1)) Vaya con Dios, Chuck, CABGx3 "snugs25" wrote: How can i re-arrange a list of text (which are names) in such a way: for example changing Bob Smith to: Smith, Bob. is there an easier way of doing it than manually so that i can apply it to a large list? Thanks! Gem |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Resetting default row height to allow display of wrapped text | New Users to Excel | |||
Text shown up in other cells everytime a text is entered in 1 cell | Excel Discussion (Misc queries) | |||
Finding Specific Text in a Text String | Excel Worksheet Functions | |||
SUMPRODUCT vs Text??? | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |