I have strings that I need to pull the first word out of. The problem is, that the first word is either delimited by a space, or an underscore. I have been using the below formula to find the first word if separated by a space, but unclear how to add the OR to look for an underscore.
=IF(ISERR(FIND(" ",A1)),"",LEFT(G10,FIND(" ",A1)-1))
Two exampled of text I would need to pull out:
1. [TABLE="width: 347"]
<colgroup><col></colgroup><tbody>[TR]
[TD]BigStar Movies - CA - RON - Connected TV / CTV - Video
2. [TABLE="width: 347"]
<colgroup><col></colgroup><tbody>[TR]
[TD]TubiTV_CA - RON (Telaria)- Connected TV / CTV - Video[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
In option 1, I would need to pull in BigStar Movies, and in option 2 I would need to pull in TubiTV, so need a formula that will search for either a space OR an underscore.
Thanks!
=IF(ISERR(FIND(" ",A1)),"",LEFT(G10,FIND(" ",A1)-1))
Two exampled of text I would need to pull out:
1. [TABLE="width: 347"]
<colgroup><col></colgroup><tbody>[TR]
[TD]BigStar Movies - CA - RON - Connected TV / CTV - Video
2. [TABLE="width: 347"]
<colgroup><col></colgroup><tbody>[TR]
[TD]TubiTV_CA - RON (Telaria)- Connected TV / CTV - Video[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
In option 1, I would need to pull in BigStar Movies, and in option 2 I would need to pull in TubiTV, so need a formula that will search for either a space OR an underscore.
Thanks!