Does anyone know how to insert text into a cell that already has data in it? At my company, I need to perform a massive journal entry. In order for the journal entry to occur, the data needs to be in a specific format.
My problem is that I have 5, 200 line items that need to be uploaded into our system. Each line item contains a check number. For example:
123456
But I need the check number to be like this, all in the same cell:
* Check #123456
So I need to insert:
* Check #
before the check number, all in the same cell.
Does anyone know??? Thanks!!
My problem is that I have 5, 200 line items that need to be uploaded into our system. Each line item contains a check number. For example:
123456
But I need the check number to be like this, all in the same cell:
* Check #123456
So I need to insert:
* Check #
before the check number, all in the same cell.
Does anyone know??? Thanks!!