If you have text that you want broken out into separate columns, like in the case of separating street numbers and road names for easier searching, you can have CALC sort the data.
TYPE 1: What you want separated is lined up
0200 Webbs Mills Road |
2563 Roosevelt Trail |
TYPE 2: Numbers are not uniform