Two charts below, chart 1 "First" and chart 2 "update". I want to be able to take A1 in "first" and shorten it for say "TennisBalls, LLC nyc Champion" in A2. Same for A3/A4 with Brick, LLC. I have 1000 invoices I need to shorten by just saying the vendor name rather than the full bill payment info. Please help.
<tbody>
</tbody><colgroup><col><col><col span="2"><col></colgroup>
First | ||||
A | B | C | D | |
1 | Bill Payment #tennisball 5.5.18 Wire - TennisBalls, LLC nyc Champion | Bill | 1/9/2018 | ($3,740.52) |
2 | Bill | 1/9/2018 | ($3,740.52) | |
3 | Bill Payment #Brick ACH Auto Debit 01.02.18 - Brick, LLC | Bill | 1/10/2018 | ($5,557.18) |
4 | Bill | 1/10/2018 | ($5,557.18) | |
5 | Bill Payment #To ACH - Tahoe, Inc | Bill | 1/17/2018 | ($4,559.00) |
6 | Bill | 1/17/2018 | ($4,559.00) | |
Update | ||||
A | B | C | D | |
1 | Bill Payment #tennisball 5.5.18 Wire - TennisBalls, LLC nyc Champion | Bill | 1/9/2018 | ($3,740.52) |
2 | TennisBalls, LLC nyc Champion | Bill | 1/9/2018 | ($3,740.52) |
3 | Bill Payment #Brick ACH Auto Debit 01.02.18 - Brick, LLC | Bill | 1/10/2018 | ($5,557.18) |
4 | Brick, LLC | Bill | 1/10/2018 | ($5,557.18) |
5 | Bill Payment #To ACH - Tahoe, Inc | Bill | 1/17/2018 | ($4,559.00) |
6 | Tahoe, Inc | Bill | 1/17/2018 | ($4,559.00) |
<tbody>
</tbody><colgroup><col><col><col span="2"><col></colgroup>