everblazing
Board Regular
- Joined
- Sep 18, 2015
- Messages
- 156
HI
Im trying to have the below two formulas combined so that i can remove the first part of text before space and last of a text in same cell after " (".
appreciate any help.
text in cell A2 [TABLE="width: 468"]
<tbody>[TR]
[TD="class: xl64, width: 468"]200593 Senior Products Systems (United)[/TD]
[/TR]
</tbody>[/TABLE]
the formula in B2 this cuts out anything before space.
=MID(A2,FIND(" ",A2)+1,256)
this cuts out anything with " (" and after
=LEFT(B15197,FIND(" (",B15197)-1)
I need them combined.
thanks
Im trying to have the below two formulas combined so that i can remove the first part of text before space and last of a text in same cell after " (".
appreciate any help.
text in cell A2 [TABLE="width: 468"]
<tbody>[TR]
[TD="class: xl64, width: 468"]200593 Senior Products Systems (United)[/TD]
[/TR]
</tbody>[/TABLE]
the formula in B2 this cuts out anything before space.
=MID(A2,FIND(" ",A2)+1,256)
this cuts out anything with " (" and after
=LEFT(B15197,FIND(" (",B15197)-1)
I need them combined.
thanks