Custom Sort List

[ladywildcat]

I am looking to create a custom sort list for my data. The data I wish to sort is below:

• Text C
• Text D
• Text 8
• Text 1
• Text M

I would like to sort the data by having the alpha first and the numeric last (the excel default is numeric first, then alpha) - see below:

• Text C
• Text D
• Text M
• Text 1
• Text 8

I have tried to create a custom list by writing out the alpha then the numeric (A,B,C....Z,0,1,2,...9) but that doesn't seem to change anything.

Since the word "text" is in each piece of data, I cannot change the format to a "number" format.
Also, I cannot manipulate original data since it is pulled from another source.

Please help!

 

[Andrew Poulsom]

Could you use a formula like:

=RIGHT(A1,1)

in an adjacent column and sort both columns by the formula column using your custom sort?

 

[ladywildcat]

This doesn't seem to produce the result I want.

I am not sure why the custom sort is not working. The word "text" is included in each line of data. I would like it to recognize the Text 8 and place this after the Text M

 

[Andrew Poulsom]

It worked for me. What steps did you take exactly?