Mrs.Meeker
Registered User.
- Local time
- Today, 12:34
- Joined
- Mar 28, 2003
- Messages
- 172
I'm faced with another interesting sort issue. I have been studying about functions Left, Mid, and Right. I can't seem to get anything to work. I need to sort from beginning to end and not from left to right. I have numbers and letters both. I have read old posts and can't find any help. I had another sort issue that was turned around the other way and I can't seem to grasp the concept. I was also reading about the function Val () and can't find anything in help about it.
Anyway this is how the numbers are set up.
1.1a
1.1b
1.1c (etc)
1.2a
1.2b
1.2c (etc)
~~
10.1a
10.1b
10.1c
Having the same old trouble of sorting left to right with the ten before the two. Sort Ascending is not enough (of course!)
I've read I need to extract the numeric portion of the string. Format the numberic pieces with leading zero's "0000" and sort on the column of formatted numbers. I'm stuck!
Thanks for any help!
Rhonda
PS Can someone explain the function InStr to me?
Anyway this is how the numbers are set up.
1.1a
1.1b
1.1c (etc)
1.2a
1.2b
1.2c (etc)
~~
10.1a
10.1b
10.1c
Having the same old trouble of sorting left to right with the ten before the two. Sort Ascending is not enough (of course!)
I've read I need to extract the numeric portion of the string. Format the numberic pieces with leading zero's "0000" and sort on the column of formatted numbers. I'm stuck!
Thanks for any help!
Rhonda
PS Can someone explain the function InStr to me?
Last edited: