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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

display contents of preceeding cells consecutively 15
sort alphabebically ignoring preceeding symbols or numbers 2
group rows between blank rows 1
sort non delimeted non fixed width alpha numeric column 2
hiding individual characters in Excel 6
How to type each letter of the alphabet automatically in a specific color in Word? 0
How fill cells with alpha series? 3
Concatinating a string of numbers - how? 5

Back
Top