Questions? We have answers.

Copying account and account description information in Excel

  • Updated

Summary

Learn how to copy account and account description data into a new column in Excel.


Instruction

In this example, we will copy a file's Account Number and Account Description information (currently contained in the same cell), then split this information into separate columns.

  1. Begin by creating an empty column to the left of the current account information.image_-_2021-01-07T124456.106.png

  2. For all the rows containing data, use the formula below to copy the account information.
    =IF(ISTEXT(B6),B6,A5)

    This formula states that if cell B6contains text, then copy that cell. If B6 does not contain text, copy the above cell. This will allow account information to be copied until a new account is encountered.

    2019-06-19_16-06-45.png

  3. Copy the formula to the bottom of the file by selecting the cell containing the formula and using the Fill to Bottom function.image_-_2021-01-07T124529.707.png

  4. Copy the account information column.
  5. Paste as Values.
    image_-_2021-01-07T124546.622.png

  6. Your data will now look like the screenshot below and is ready to be saved.image_-_2021-01-07T124605.586.png
 

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.

Was this article helpful?