Questions? We have answers.

Separating cell data in Excel

Article author
Jonathon Plowman-Samson
  • Updated

Summary

Learn how to split data into different cells in Excel.


Splitting data

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 will split the Account Number and Account Description from the same cell.

image_-_2021-01-07T124215.256.png
 
  1. Begin by creating 2 new columns to the left of the data. We will be splitting and labeling each column with Account Number and Account Description.image_-_2021-01-07T124231.213.png
  2. 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
  3. 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
  4. 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. Go to the final row of data and click it while holding the Shift button. 

    With both columns selected, use 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 in separate columns, as shown below.

    image_-_2021-01-07T124338.310.png 
  5. Select columns A and B and Copy and Paste as Values to remove the formulas.image_-_2021-01-07T124352.697.png
  6. Your file is now ready to be re-saved.

 


Anything else on your mind?

Head over to the community with your thoughts and inquiries! You can also chat with us, or, submit a request for further assistance.


Related Articles

Share this:

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.