Sort question

[StephanieJ]

Is there anyway to sort in alphabetical order by last name when the names are placed in one cell as they are below?

A 1-----First name Last name

A2-----First name Last name

Thank you very much.

[Bryan Hessey]

Is there anyway to sort in alphabetical order by last name when the names are placed in one cell as they are below?

A 1-----First name Last name

A2-----First name Last name

Thank you very much.

Hi,

You could extract the Last Name to a helper column and sort over that.

---