Extract numbers from right of data set after ""

[alimumtaz13]

Hi All,

what would be the formula for extracting the underlined set out of below data appearing in single cell?

Purchase invoice IV-PI19-HSAU &

<tbody>
</tbody><colgroup><col></colgroup>

Purchase invoice INV0243803 Thanks, Ali <tbody> </tbody><colgroup><col></colgroup>

<tbody>
</tbody><colgroup><col></colgroup>

 

[JoeMo]

Assuming the part you want to extract will always be at the end of the string and contain no spaces, maybe:
Sheet2

*	A	B
1	Purchase invoice IV-PI19-HSAU	IV-PI19-HSAU
2	Purchase invoice INV0243803	INV0243803

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:201px;"><col style="width:90px;"></colgroup><tbody>
</tbody>

Spreadsheet Formulas

Cell Formula B1 =TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",100)),(LEN(A1)-LEN(SUBSTITUTE(A1," ",""))-1)*100)) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

 

[alimumtaz13]

Thanks mate

 

[JoeMo]

Thanks mate

You are welcome - thanks for the reply.