Formula to sort names in alphabetical order?

C

Christina

What formula do I use to sort names in Excel? The list is typed with the
whole name in one cell ex. "Dave Smith", "Chris Johnson". I need to sort the
list by the last name or somehow re-arrange the names to use the sort feature.
 
M

Myrna Larson

Yes, you need to do the latter. If you have only 1st and last names, with just
one space (i.e. not De La Renta, but DeLaRenta, as the last name) you can use
Data/Text to columns to split the names into 2 columns at the space.

What formula do I use to sort names in Excel? The list is typed with the
whole name in one cell ex. "Dave Smith", "Chris Johnson". I need to sort the
list by the last name or somehow re-arrange the names to use the sort
Click to expand...
feature.
 
F

Frank Kabel

Hi
split the names in two columns (e.g. use 'Data - Text to columns' for
this)
 
Top