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

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?

Tommy Boy wrote:
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

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

"Gordon" wrote:

Tommy Boy wrote:
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

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.



Tommy Boy wrote:

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

"Gordon" wrote:

Tommy Boy wrote:
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




--

Dave Peterson

Dave

Thank you very much. It worked as you suggested.

TOMMY BOY

"Dave Peterson" wrote:

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.



Tommy Boy wrote:

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

"Gordon" wrote:

Tommy Boy wrote:
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




--

Dave Peterson