How to separating first and last name (in a single cell...

[Guest]

I have a worksheet with a persons name in a single cell. I need to sort
these and I forget how to separate them to another set of cells to get the
last name. Since some names have 2, 3, 4 or more separate item (ex: Thomas
G. Roberts, CPA) I can figure it out.

Any help appreciated?

 

[Gordon]

I have a worksheet with a persons name in a single cell. I need to
sort these and I forget how to separate them to another set of cells
to get the last name. Since some names have 2, 3, 4 or more separate
item (ex: Thomas G. Roberts, CPA) I can figure it out.

Any help appreciated?

Text to Columns

 

[Guest]

Gordon

Thank you but I tried that and you get 1,2,3,4 or 5 columns this way and
they are not in order. Last name could be in column 2, 3,4 etc. Doesn't
help me in my sort.

Any other ideas?/

Thanks

 

[Dave Peterson]

When I do this, I use Data|Text to columns.

But then I go back and put in a formula in a helper cell.

=counta(A1:E1)

Then I sort by that column (names that look like 2 parts are grouped together
after the sort).

Then it's a manual effort (just dragging the cells to their correct columns).

But since I grouped them nicely, (if I'm lucky) I can grab a few rows of data at
one time and move them to the right/left.

 

[Guest]

Dave

Thank you very much. It worked as you suggested.

TOMMY BOY