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