Product: ImportOmatic
Description: This solution discusses how to parse data into separate columns
Environment: All
Version: All


Open Excel, highlight the entire column that needs data parsed and select "Text to Columns" from the "Data" menu in the toolbar: 

1. Make sure that Delimited is selected and then click Next.

2. On the next page, make sure to select the correct delimiter(s), depending on your data file delimiters. (In this example, the delimiter is the "-" symbol. The "-" symbol may be entered as "Other" and place the "-" symbol in the open field, see below):

3. Click the Finish button to apply the parsing by the selected delimiter: 

4. In this example, the initial value of 3968-1201-1-126021-175279 will now be parsed into separate columns based on the "-" delimiter used: