Introduction

Sometimes suppliers provide spread sheet data that has two different pieces of information in the one cell and you need to separate it so that you can import it correctly.

Separate Data from one column to multiple columns 

In this example (Fig 1.) the supplier has placed the code and description in the same field and we need to separate it into two different fields. We will separate all text into separate columns first, then you can merge back words you want to have in one column.

Fig. 1. Shows Code and description in a single cell

1.      Make sure that you have enough empty columns to the right of the column for the words to be separated into.

2.      Select the Column to be separated (1), Select the Data Tab (2), Select Text to Columns (3)

3.      Ensure that the Delimited Choice is selected and press Next.

4.      Select all check boxes as per the below screen shot and press Next.

5.      Select all check boxes as per the below screen shot and press Finish.

6.      The data is now separated

Here watch this