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

R

Rusty

I am trying to sort a group of numbers with and without letters ex 1000 1000a
1002 and so on
 
N

Niek Otten

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
| > [email protected]
| > 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
| >
 
R

Rusty

well niek I am a rel beginner and I have excell 2003 but cant figure out how
to do this
thanks
rusty
 
Top