seperating strings in Excel

[rickgalty]

I have been sent an employee listing as an Excel file. The first column is in the form of:

Jones, Peter A
Smith, Richard Alan
Johnson, Bert

etc etc...... I want to split this into three columns. Last name, First name, middle name or initial (Which will sometimes be a name, sometimes an initial, and sometimes blank.

How can I do this other than manually?

Thanks,
Richard

 

[AnotherHiggins]

If all of you data follows that pattern, then
Data > Text To Columns.

Choose Delimited.

Select Comma and space.

Select Treat consecutive delimiters as one.

Press Finish.

[!]Note[/!]: If you have employees with four names, they will be separated into four columns.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[rickgalty]

Thank you sir, that did it.

Incidentally, I like your tagline quote.

Richard