I cannot find a function or write a formula that will allow me to delete characters from the left of a text string. Our bank only issues statement is a pdf format. I am able to convert pdf to EXCEL via Acrobat PC, but the data for the company making an EFT transfer is preceded by "CCD DEPOSIT, " followed by the company name. Consequently. I am unable to sort the data by company name. Manually deleting this phrase in each line would be very time consuming and since the text string are different lengths for almost evert transaction, using the TEXT RIGHT function to select the text elements over to the first letter of the company name is also very time consuming.
Attached is a sample of the text strings. It would seem that deleting the "CCD DEPOSIT,(space)" would be the easiest solution.
I appreciate any help and thoughts that you might have to addressing this problem.
Pete
Bookmarks