Sorting alpha numeric data

  • Thread starter Thread starter teetee209
  • Start date Start date
T

teetee209

I have a very large data base (9,000 +) with a column of numbers such as:
K-8345-08; B-8346-08; O-8347-08. Is it possible to sort this data by number
only and ignore the letter and hyphen? Can this be done with out adding a
secondary column?
 
I think you'll need the helper column.
I have a very large data base (9,000 +) with a column of numbers such as:
K-8345-08; B-8346-08; O-8347-08. Is it possible to sort this data by number
only and ignore the letter and hyphen? Can this be done with out adding a
secondary column?
Click to expand...
 

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

Keep cell position in a formula after data is deleted 2
Find earliest date combined with status 2
Setting up account headings for sorting data that is dynamic 10
Alpha sorting (with a twist...?) 3
Separating Numerical and Alpha Data in cells 6
Formula needed please 7
Sorting rows of data of varying lengths 12
sorting numerical data 2

Back
Top