I need a formula to extract the charge amount from text
Chase bank only lets me download 90 days of transactions. To go further back, I am copy/pasting from older PDF statements and this is how it turns out:
01/13 CHEWY.COM 800-6724399 FL 115.56
01/14 AT&T*BILL PAYMENT 800-331-0500 TX 226.06
01/15 AMAZON MKTPLACE PMTS AMZN.COM/BILL WA 21.89
01/15 T.J. MAXX # 1228 CRANSTON RI 53.29
01/15 TJMAXX #0315 WARWICK RI 239.50
01/15 WHOLEFDS CRN 10254 CRANSTON RI 279.29
01/16 NEW YORK TIMES DIGITAL 800-698-4637 NY 7.50
I want to split this to three columns. One each for date, description, and amount.
I am obviously able to use Text to Columns using fixed width to split the date from the rest. That creates two columns. Then I need to grab the dollar amount and split that to a 3rd column. I recorded a macro using my keyboard keys to edit, move the cursor backward to the final space character (^left-arrow 3x), then select to the end, cut the text, and paste. The VB created didn't capture my intent even closely, so I am back to using a formula.
How can I create a 3rd column having only the transaction amount?
Thanks Jamie
Bookmarks