Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ParsingCellData
A column in the spreadsheet has the names like this:
Smith, Bob R I need to parse them out and put them in 3 seperate columns like so: Smith Bob R. Does anyone have a macro or formula to do this? TIA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ParsingCellData
Select the column and do Data=Text to Columns. Choose delimited and in the
next dialog specify the comma as your delimiter. -- Regards, Tom Ogilvy "rj" wrote in message ... A column in the spreadsheet has the names like this: Smith, Bob R I need to parse them out and put them in 3 seperate columns like so: Smith Bob R. Does anyone have a macro or formula to do this? TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|