I'm trying to figure out a way to pull specific text from a long mesh of test in a cell (R). For example,
<tbody>
</tbody>
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:
<tbody>
</tbody>
"SF123811#ARR676#Unbilled AR Trueup" this is an example of what could be in cell R |
<tbody>
</tbody>
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:
"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). |
<tbody>
</tbody>