# Questions? We have answers.

## Summary

Learn how to split data into different cells in Excel.

---

## Split cell 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 one cell to form both the Account Number and Account Description from the same cell.

01. Begin by creating **2 new columns** to the left of the data.  
02. Labeling each column:
    - **Account Number**  
    - **Account Description**  
03. Split the account number using the formula below:

```
    =LEFT(C6,5)
    ```

In this example, each Account Number is 5 digits long. This formula will copy the 5 leftmost characters of cell C6.

04. **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, and skip the account number:

```
    =MID(C6, 7, 100)
    ```

05. Select both formulas contained in columns A and B and **copy** them to the bottom using the **Fill to Down** function.  
06. Select cells A6 and B6, and scroll to the final row.  
07. Select the final row while holding down **Shift** on your keyboard.  
08. With both columns selected, go to the Editing tab in the Home ribbon and select **Fill**.  
09. Select **Down** from the menu options that appear.

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

10. Select columns A and B.  
11. **Copy** the contents of the 2 columns  
12. **Paste** as **Values** to remove the formulas.

13. Save your file.