extract data from string of text

Hi

Could you pls help me to extract "-6,0%" from the following string of text?

Pls see attached file.

thanks

This formula will do that for you:

=MID(A1,FIND("-",A1),5)

Hope this helps.

Pete

Or try:

=IFERROR(TRIM(RIGHT(SUBSTITUTE(LEFT(A1,SEARCH("</font>",A1)-1),">",REPT(" ",20)),20)),"")

=-LOOKUP(1,-MID(A1,FIND("</font>",A1)-{1,2,3,4,5,6,7},{1,2,3,4,5,6,7}))

Originally Posted by Pete_UK

This formula will do that for you:

=MID(A1,FIND("-",A1),5)

Hope this helps.

Pete

Thanks. The numbers within the string of text may differ e.g. -60%, -60,8%, etc. Need a formula that would be able to handle these variations.

Originally Posted by jeffreybrown

Is this all you have, one sample? Surely there is more... If so, please update your sample to show many different samples.

If this is it, just use >> Data >> Text to Columns >> Fixed Width

Thanks. The numbers within the string of text may differ e.g. -60%, -60,8%, etc. Need a formula that would be able to handle these variations.

Perhaps…….

In B1, enter :

=FILTERXML(A1,"//font")

Regards
Bosco