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.
<colgroup><col></colgroup><tbody>
</tbody>
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.
BigStar Movies - CA - RON - Connected TV / CTV - Video 2.
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col></colgroup><tbody>
</tbody>
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!