alphabetical sort while ignoring preceeding numbers/symbols

S

silver fox

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

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