Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mimitrem

    Sorting data that are strings as integer

    Ok guys I see I haven't been clear the thing is I got all sorts of values I have integer and the in the strings I have things like 4F, F, F 4, F4, 1-D, etc. And I got to sort in some kind of order.
  2. mimitrem

    Sorting data that are strings as integer

    Thanks Guys it works a lot better now but can I do something about sorting like 9 B C 10 and such ?
  3. mimitrem

    Sorting data that are strings as integer

    Hi, your solution does help but now my problem is that the values that are strings get transformed into 0 like 3B becomes 0 This is my formula if NumericText ({Volume}) then val({Volume}) but it's seems like all the data is evaluated by val even if NumericText() returns false.
  4. mimitrem

    Sorting data that are strings as integer

    HI, I want to sort data like 1,2,3,11,2B they are strings so when sorted it looks like this 1 11 2 2B 3 I would like to sort the numbers as integer and then just leave the strings as string but I just don't know how. Could somebody help please ? I want a result like 1 2...

Part and Inventory Search

Back
Top