ParsingCellData

R

rj

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
 
T

Tom Ogilvy

Select the column and do Data=>Text to Columns. Choose delimited and in the
next dialog specify the comma as your delimiter.
 
Top