Dear all
I have a problem in sorting the following
G1 to G40
When I do sorting , it shows this. It there any way I can solve this ?
G1
G10
G11
G12
G13
G14
G15
G16
G17
G18
G19
G2
Eric
Dear all
I have a problem in sorting the following
G1 to G40
When I do sorting , it shows this. It there any way I can solve this ?
G1
G10
G11
G12
G13
G14
G15
G16
G17
G18
G19
G2
Eric
You have to include zeros as placeholders to the maximum value you expect to encounter.
If you do not expect to hit G100, then put a 0 in front of every value under 10 (i.e. G02)
If you expect to exceed 100 (but not 1000) then you need an additional zero (i.e G002 and G015)
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
you can try
your data is in A1:A12
in B1: =--MID(Q1,2,LEN(Q1)) and drag down
select A1:B12
use SORT from Ribbon by column B (smallest to largest
after that you can delete helper column B
Last edited by sandy666; 05-23-2017 at 10:13 AM.
Dear Sandy666 and Chemist
I tried both method, it shows
G1
G10
G11
G12
G13
G14
G15
G16
G17
G18
G19
G2
G20
G21
G3
I made mistake
in B1: =--MID(A1,2,LEN(A1))
see att. algorithm is the same
Last edited by sandy666; 05-23-2017 at 05:16 PM.
Sandy
This is still not working
See the movie in zip
or attach example xlsx file because I don't know what kind of characters you are using, local or something
Suppose your data from "A2" to "A13"
Enter formula in "B2"copy downFormula:Please Login or Register to view this content.
then sort with helper column. [column "B" is helper]
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks