So i have a column full of first and surnames (both names in one cell).
Is there a fast way to arrange them in alphabetical order? (surnames)
So i have a column full of first and surnames (both names in one cell).
Is there a fast way to arrange them in alphabetical order? (surnames)
if all the names are just first and last and so you have on space only
copy the column into a helper column
then on that helper column - use
DATA > TEXT to columns
delimited > SPACE
now all the surnames are in a column of there own
select the range including your original list and sort by the new surmane list
see here http://www.extendoffice.com/document...last-name.html
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hi,
It would be far simpler if you simply extracted the first names and surnames into their own columns, and then sorted on those.
Have a look at the Text to Columns feature (Data tab).
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks