Hey Lisa,

See if this works. Insert a new column next to the name. Highlight the names
in the list.

Go to Data ---- Text To Columns

Select the Deliminited option
Now check the box that says Space and then
Click finish.

Let me know if this works.

"Lisapbs" wrote:

I inherited a worksheet where first and last name are combined in one cell
(i.e. Jane Doe) The first name is listed first. Can I sort this this by the
LAST name? How? If not, how can I split the text into two cells FIRST NAME
and LAST NAME?

Thanks! Lisa