Home‎ > ‎Hints & Tips‎ > ‎

Excel Text To Columns

Once you have downloaded your report and opened in Excel highlight the column A then select Data Tab and then select Text to Columns.

On the pop up screen select Delimited and then select Next.

Tick Other and type | character in the text field.  Then select Finish.
Note - | character is created when shift and \ are pressed at the same time ( \ is above the return/enter key).

The Excel spreadsheet is now ready for user to edit.