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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mimitrem

  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...
See more

Part and Inventory Search

Back
Top