How do you pull particular information out of a single word cell in order to shorten it?

[exalex]

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.


[TABLE="width: 599"]
<tbody>[TR]
[TD][/TD]
[TD]First[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]Bill Payment #tennisball 5.5.18 Wire - TennisBalls, LLC nyc Champion[/TD]
[TD]Bill[/TD]
[TD]1/9/2018[/TD]
[TD]($3,740.52)[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD]Bill[/TD]
[TD]1/9/2018[/TD]
[TD]($3,740.52)[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD]Bill Payment #Brick ACH Auto Debit 01.02.18 - Brick, LLC[/TD]
[TD]Bill[/TD]
[TD]1/10/2018[/TD]
[TD]($5,557.18)[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD]Bill[/TD]
[TD]1/10/2018[/TD]
[TD]($5,557.18)[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD]Bill Payment #To ACH - Tahoe, Inc[/TD]
[TD]Bill[/TD]
[TD]1/17/2018[/TD]
[TD]($4,559.00)[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD]Bill[/TD]
[TD]1/17/2018[/TD]
[TD]($4,559.00)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Update[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]Bill Payment #tennisball 5.5.18 Wire - TennisBalls, LLC nyc Champion[/TD]
[TD]Bill[/TD]
[TD]1/9/2018[/TD]
[TD]($3,740.52)[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD]TennisBalls, LLC nyc Champion[/TD]
[TD]Bill[/TD]
[TD]1/9/2018[/TD]
[TD]($3,740.52)[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD]Bill Payment #Brick ACH Auto Debit 01.02.18 - Brick, LLC[/TD]
[TD]Bill[/TD]
[TD]1/10/2018[/TD]
[TD]($5,557.18)[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]Brick, LLC[/TD]
[TD]Bill[/TD]
[TD]1/10/2018[/TD]
[TD]($5,557.18)[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD]Bill Payment #To ACH - Tahoe, Inc[/TD]
[TD]Bill[/TD]
[TD]1/17/2018[/TD]
[TD]($4,559.00)[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD]Tahoe, Inc[/TD]
[TD]Bill[/TD]
[TD]1/17/2018[/TD]
[TD]($4,559.00)[/TD]
[/TR]
</tbody><colgroup><col><col><col span="2"><col></colgroup>[/TABLE]

 

[jtakw]

Hi,

If All your data is in the format as shown in your sample, this formula will extract the info you want.
However, the problem here is you have the original data and the data you want extracted in the same Column, meaning you Can't just copy the formula down column.

Book1
	A	B	C	D
1	Update
2	Bill Payment #tennisball 5.5.18 Wire - TennisBalls, LLC nyc Champion	Bill	1/9/2018	($3,740.52)
3	TennisBalls, LLC nyc Champion	Bill	1/9/2018	($3,740.52)
4	Bill Payment #Brick ACH Auto Debit 01.02.18 - Brick, LLC	Bill	1/10/2018	($5,557.18)
5	Brick, LLC	Bill	1/10/2018	($5,557.18)
6	Bill Payment #To ACH - Tahoe, Inc	Bill	1/17/2018	($4,559.00)
7	Tahoe, Inc	Bill	1/17/2018	($4,559.00)
Sheet41

Cell Formulas
Range	Formula
A3	=MID(A2,FIND("-",A2)+2,255)
A5	=MID(A4,FIND("-",A4)+2,255)
A7	=MID(A6,FIND("-",A6)+2,255)

 

[exalex]

Thank you!

 

[jtakw]

You're welcome.