I am preparing my bank statements for tax time. I need them sorted by the business I transacted with, but my bank often titles the transactions with "Checkcard 0123" here's an example
CHECKCARD 0108 LUMBER LIQUIDATORS 1352 TORRANCE CA
I would like it to read
LUMBER LIQUIDATORS 1352 TORRANCE CA 2443
Sometimes the cells do not contain the "checkcard" word and doesn't need modifying, I have about 2000 rows to be sorted in column B.
Any help would be awesome. If it makes any difference, I am using Open Office
Thanks a bunch!
CHECKCARD 0108 LUMBER LIQUIDATORS 1352 TORRANCE CA
I would like it to read
LUMBER LIQUIDATORS 1352 TORRANCE CA 2443
Sometimes the cells do not contain the "checkcard" word and doesn't need modifying, I have about 2000 rows to be sorted in column B.
Any help would be awesome. If it makes any difference, I am using Open Office
Thanks a bunch!
Last edited by a moderator: