I have converted bank statements from PDF to Excel and now need help identifying the vendors in the line detail of the transactions. I can clean up some statements using Text to column but need help separating the vendors from the other text. Any help would be greatly appreciated. Once I have identified the vendors the rest of the process of coding the transactions falls into place.
[TABLE="width: 590"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Purchase authorized on 12/23 Shell Oil 57542184 Porter TX S586358651969453 Card [/TD]
[/TR]
[TR]
[TD]Purchase authorized on 12/23 Audible Adbl.CO/Bill NJ S466358683933481 Card [/TD]
[/TR]
[TR]
[TD]Purchase authorized on 12/26 Chachis Mexican Ba Kingwood TX S586362016700893 [/TD]
[/TR]
[TR]
[TD]Purchase authorized on 12/26 Chachis Mexican Ba Kingwood TX S386362053254567 [/TD]
[/TR]
[TR]
[TD]Purchase authorized on 12/27 Buc-Ee's #18 Waller TX P00586362581968682 Card [/TD]
[/TR]
[TR]
[TD]Purchase authorized on 12/27 Star Stop #63 Porter TX P00306362821478078 Card [/TD]
[/TR]
</tbody>[/TABLE]
Above is a copy of some lines from one bank statement. Each line does end with Card XXXX or mearly says Check. Check number, amount, date, etc are in separate columns.
Thank you for your help.
M4ckx
[TABLE="width: 590"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Purchase authorized on 12/23 Shell Oil 57542184 Porter TX S586358651969453 Card [/TD]
[/TR]
[TR]
[TD]Purchase authorized on 12/23 Audible Adbl.CO/Bill NJ S466358683933481 Card [/TD]
[/TR]
[TR]
[TD]Purchase authorized on 12/26 Chachis Mexican Ba Kingwood TX S586362016700893 [/TD]
[/TR]
[TR]
[TD]Purchase authorized on 12/26 Chachis Mexican Ba Kingwood TX S386362053254567 [/TD]
[/TR]
[TR]
[TD]Purchase authorized on 12/27 Buc-Ee's #18 Waller TX P00586362581968682 Card [/TD]
[/TR]
[TR]
[TD]Purchase authorized on 12/27 Star Stop #63 Porter TX P00306362821478078 Card [/TD]
[/TR]
</tbody>[/TABLE]
Above is a copy of some lines from one bank statement. Each line does end with Card XXXX or mearly says Check. Check number, amount, date, etc are in separate columns.
Thank you for your help.
M4ckx
Last edited: