HOW DO I SORT NUMBERS WITH TEXT EX 1000 1001 1000A

  • Thread starter Thread starter Rusty
  • Start date Start date
R

Rusty

I am trying to sort a group of numbers with and without letters ex 1000 1000a
1002 and so on
 
I change the column to text but it dosent change the way it sorts

rusty
 
Hi Rusty,

Just formatting doesn't change the nature of the data.
Use a helper column; formula =TEXT(A1,"@"), copy down as far as needed.
Select, Edit>Copy>Paste special>Values and use that column as sort key.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


|I change the column to text but it dosent change the way it sorts
|
| rusty
|
| "Nick Hodge" wrote:
|
| > Rusty
| >
| > Format them all as text
| >
| > --
| > HTH
| > Nick Hodge
| > Microsoft MVP - Excel
| > Southampton, England
| > (e-mail address removed)
| > web: www.excelusergroup.org
| > web: www.nickhodge.co.uk
| >
| >
| >
| >
| >
| > | > > I am trying to sort a group of numbers with and without letters ex 1000
| > > 1000a
| > > 1002 and so on
| >
 
well niek I am a rel beginner and I have excell 2003 but cant figure out how
to do this
thanks
rusty
 
Thank you VERY MUCH Niek I finally figured it out with your help thanks again

Rusty
 
You must log in or register to reply here.

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

sorting numbers and numbers that contain text in excel 2
how to filter by the first digit of list 1
Dynamic unbound textbox on a continous form 2
Identifying missing numerical values in a series 6
Exported data to Excel 2007 has spaces between rows 1
Sorting with empty cells 5
Drop down list showing different value 3
Need Help Creating a ID Number 24

Back
Top