alphabetical sort while ignoring preceeding numbers/symbols

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to do an alphabetical sort while ignoring preceeding numbers
and symbols? That is, sort based on the first letters in a string of
characters.
 
On Sat, 1 Oct 2005 16:10:02 -0700, "silver fox" <silver
Is it possible to do an alphabetical sort while ignoring preceeding numbers
and symbols? That is, sort based on the first letters in a string of
characters.
Click to expand...

You can use a "helper column". In an adjacent column, insert a formula similar
to =LEFT(A1,2). Then select both columns and sort on the helper column.


--ron
 
Back
Top