Instructions to use excel for data formating

If your export looks as below – you can format the data using the below steps.

 

Step 1: open your file in MS Excel

Step 2: Click on first column, in my example column A

Step 3: Now click on menu ‘Data’

Step 4: Click on icon ‘Text to Columns’ and from popup select ‘Delimited’ as shown below. Now click Next button

Step 5: Select ‘Semicolon’ from option and click Next button

Step 6: From screen select ‘General’ and click finish

Result: