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

200 Webbs Mills
2563 Roosevelt Trail
84 Mill Street

(If this is the case you will need to put a comma between the what you want separated as the delimiter. The only time this is not the case is when there what you want separated in consistently divided by a space).

 

  1. Highlight the column that you want delineated.
  2. Under "Data" choose "Text to Columns"
  3. If TYPE 1, choose "Fixed width" under Separator options then on the bottom half of the page it gives at example of the text along a ruler bar. Click where you want the separation to occur and a line will show up indicating the the proposed change.
  4. If TYPE 2, either choose "Commas" or "Spaces" as the delimiter and example on the bottom will show how the change will affect the data.
  5. When you are done making changes, click "OK" and "OK" in the pop up box.
  6. The header will also be split so you may have to rename them.
Taxonomy upgrade extras: 
Drupal