In some cases, the data found in a single cell must be separated into different cells before it can be imported into MindBridge.
In this example, we'll split the Account Number and Account Description from the same cell:
Begin by creating two new columns to the left of the data we will be splitting and label each column with Account Number and Account Description:
We will split the account number using the formula below:
In this example, each Account Number is five digits long. This formula will copy the first five leftmost characters of cell c6:
Copy the Account Description using the MID function. This function looks at the original data, counts 7 characters into the cell, and then copies the next 100 characters.
This formula will copy only the account description, skipping the account number
=MID(C6, 7, 100)
Select both formulas contained in columns A and B and copy them to the bottom using the Fill to Down function.
Select cells A6 and B6, and scroll to the final row. Click on the final row of data and click it while holding the Shift button.
With both columns selected, use the the Fill to Down function. From the Editing tab in the Home ribbon, click Fill to open the drop-down menu and click Down.
Your dataset will now have the Account Numbers and Account Descriptions on separate columns, as shown below:
Select columns A and B and Copy and Pasted as Values to remove the formulas.
Your file is now ready to be re-saved.