sorting

P

Patrick

I have a column of names with last name first. I want to have Excel sort
these so that the FIRST name is first. Can this be done?
 
D

Duke Carey

You'll need to pull the first names into a different column. While you can
do that with formulas, it is usually faster & easier to insert two new
columns, copy & paste the names into the left new column, and then use
Data|Text to Columns on that copied data, splitting the names where there's a
comma or space, depending on how the list is set up.
 
Top