I'm trying to figure out a way to pull specific text from a long mesh of test in a cell (R). For example,
[TABLE="width: 546"]
<tbody>[TR]
[TD="class: xl125, width: 546"]"SF123811#ARR676#Unbilled AR Trueup"
this is an example of what could be in cell R[/TD]
[/TR]
</tbody>[/TABLE]
and this formula works when I'm trying to pull the ARR number
=LEFT(MID(R2,FIND("#",R2)+1,LEN(R2)),FIND("#",MID(R2,FIND("#",)+1,LEN(R2)))-1)
But not all the data in cell R is the same as another example in cell R123:
[TABLE="width: 546"]
<tbody>[TR]
[TD="class: xl126, width: 546"]"Reversal Of Prior Debit Unbilled Receivable Adjustment for Revenue Arrangement for ARR4628, Element: ELEM35240"
so finally to my question:
Is the something that could always get me the ARR number no matter where it is and no matter how long it is? (ARR12 as well as ARR123456789).[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 546"]
<tbody>[TR]
[TD="class: xl125, width: 546"]"SF123811#ARR676#Unbilled AR Trueup"
this is an example of what could be in cell R[/TD]
[/TR]
</tbody>[/TABLE]
and this formula works when I'm trying to pull the ARR number
=LEFT(MID(R2,FIND("#",R2)+1,LEN(R2)),FIND("#",MID(R2,FIND("#",)+1,LEN(R2)))-1)
But not all the data in cell R is the same as another example in cell R123:
[TABLE="width: 546"]
<tbody>[TR]
[TD="class: xl126, width: 546"]"Reversal Of Prior Debit Unbilled Receivable Adjustment for Revenue Arrangement for ARR4628, Element: ELEM35240"
so finally to my question:
Is the something that could always get me the ARR number no matter where it is and no matter how long it is? (ARR12 as well as ARR123456789).[/TD]
[/TR]
</tbody>[/TABLE]