What does the data look like?
If it's in this format:
12345 Streetname ...
Then Leftwords ( addressField ; 1 )
will extract the street number. Select number as the calculation field's return type and you should be able to sort on this field and get the expected numeric order.
Thanks so much, That got me the numbers. I'm trying to strip the numbers and be left with the streets. The data looks like "1234 Main St" or "1234 20th St". The end goal is to be able to sort by streets making inserting Zips easier.
RightWords ( addressField ; WordCount ( addressField ) - 1 )