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

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