Questions? We have answers.

Separating a Cell's Data

Article author
Jonathon Plowman-Samson
  • Updated

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:

image_-_2021-01-07T124215.256.png

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:

image_-_2021-01-07T124231.213.png

We will split the account number using the formula below:  

=LEFT(C6,5)

In this example, each Account Number is five digits long. This formula will copy the first five leftmost characters of cell c6:

image_-_2021-01-07T124248.389.png

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)

image_-_2021-01-07T124305.220.png

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. 

image_-_2021-01-07T124321.800.png

Your dataset will now have the Account Numbers and Account Descriptions on separate columns, as shown below:

image_-_2021-01-07T124338.310.png

Select columns A and B and Copy and Pasted as Values to remove the formulas.

image_-_2021-01-07T124352.697.png

Your file is now ready to be re-saved.

Share this:

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.