Hello,
I have another code that I will need to create and I am not sure if it even is possible.
I don't have the code created yet as I do not know how to start it.
I have data that has all information in one column and I need to do a text to column in order to split the data into its own columns. The dilema I have is that from the copied data I only need to do the text to column on specific cells.
The data is:
BANK* 106** ***BANK*ACCOUNT* 11*
* *
*TRAN*******MICR*********CHECK**************CHECK********ERROR*DESCRIPTION *
*CODE*****CHECK*NO********DATE**************AMOUNT *
*____*****________*******_____**************______*******_________________ *
***0******0000001******04/25/13***************49.00*****CHECK*NOT*ON*BANK*RECON*FILE *
***0******30000002******04/25/13***************12.00*****CHECK*NOT*ON*BANK*RECON*FILE *
***0******30000003******04/25/13****************5.00*****CHECK*NOT*ON*BANK*RECON*FILE *
***0******30000004******01/24/13***************40.00*****CHECK*NOT*ON*BANK*RECON*FILE *
***0******30000005******02/15/13***************46.00*****CHECK*CANCELLED*PREVIOUSLY *
***0******30000006******02/18/13***************13.00*****CHECK*AMOUNT*INCONSISTENT*WITH*BANK*RECON,********17.00 *
***0******30000007******02/25/13***************25.00*****CHECK*NOT*ON*BANK*RECON*FILE *
***0******30000008******04/09/13****************5.00*****CHECK*AMOUNT*INCONSISTENT*WITH*BANK*RECON,********86.00 *
***0******30000009******04/09/13***************41.00*****CHECK*NOT*ON*BANK*RECON*FILE *
***0******30000010******04/09/13***************31.50*****CHECK*AMOUNT*INCONSISTENT*WITH*BANK*RECON,********26.00 * * *
TOTAL*REJECTED * * *
**COUNT**********11******AMOUNT***********279.50 *
* *
TOTAL*ACCEPTED *
* *
**COUNT*******3,289******AMOUNT*******168,199.91 *
The above data is all in column A. I want a code that will do a search for cells that start with 0. Once it finds the cells the start with 0, it should then perform a text to column on those cells.
The code that I do have is for the text to colum, which is (where ?? is, that is where the cell with 0 is).
If this is not possible to do, please let me know what other options I have.
Thank you,
~Miriam
Bookmarks