RE: sorting by name

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


Thanks Mike, strangely, it works on some cells and not others, wonder why
that would be?

"Mike H" wrote:

Hi,

You need a helper column to extract the last name with this formula

=MID(SUBSTITUTE(A1," ","~",LEN(A1)-LEN(SUBSTITUTE(A1,"
",""))),FIND("~",SUBSTITUTE(A1," ","~",LEN(A1)-LEN(SUBSTITUTE(A1,"
",""))))+1,256)

having extracted the last names in the new column sort your data on this
last name.

Mike

"dannyboy8" wrote:

if I have names formatted by Mr and Mrs John Doe all in the same column, is
thee a way to sort by last name in excel 2007? the only sort I can figure out
is alpha by 1st letter, so it begins sorting the list by the 1st letter of
the 1st names. Thanks!
.

Relevant Pages

  • Re: Script/Command to extract XYZ.ra URL from XYZ.ram files
    ... Mike: ... the sort you find all over the BBC's "Listen ... again" pages, will extract the URL within it, the real something.ra ... It is probably trivial for a knowledgeable scripter, ...
    (alt.os.linux)
  • Re: how do you format cells by time?
    ... You need to create a helper column to extract the end time into, and sort on ... HTH ...
    (microsoft.public.excel.misc)
  • Re: Sort Dates
    ... Or use a different formula in a single helper column: ... That wont work, ... Now drag these 2 column down and then do a sort first on column C ascending ... "Mike H" wrote: ...
    (microsoft.public.excel.misc)
  • Re: sort numbers based on initial digit.
    ... Use a helper column and extract the first 8 digits from the p/n then sort on ... Select the range to sort and sort on column D. ...
    (microsoft.public.excel.misc)
  • Re: Script/Command to extract XYZ.ra URL from XYZ.ram files
    ... Mike wrote: ... the sort you find all over the BBC's "Listen ... again" pages, will extract the URL within it, the real something.ra ... no idea where to find the right kind of input file. ...
    (alt.os.linux)