Alpanumeric Sorting

[S_Coupland]

Hi There, this may be a really easy question and answer, here goes.....

I have a column imported from an AutoCAD txt file, the colum is imported into Excel with random sorting, however when i go to sort it in Excel i get the following standard sorting:

Text 1
Text 10
Text 11
Text 12
Text 13
Text 14
Text 15
Text 16
Text 17
Text 18
Text 19
Text 2
Text20

How do i sort it so that it goes:

Text 1
Text 2
Text 3

etc.

Many Thnaks

Simon

 

[SpillerBD]

You have to break out the number part or move the number part to a prefix position.