Won2Ok
asked on
Excel Sort
I have a column that contains data in the format:
Alpha:Numeric.Surname,Firs tname
I want to sort on the Surname, Firstname. I don't care if the Alpha:Numeric. is deleted.
Alpha:Numeric.Surname,Firs
I want to sort on the Surname, Firstname. I don't care if the Alpha:Numeric. is deleted.
Can you give a few examples here?
Your best bet is to split the data into columns, then you'll have much more control for sorting. You can do so by clicking data, text to columns.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks