alphabetical sort while ignoring preceeding numbers/symbols

[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.

 

[Ron Rosenfeld]

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.

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