Exgtracting underlined texts.

[thilag]

Hello Friends

Please find attached 2010 excel file <The underlined texts.xlsx>.

I need to extract the undelined text and plotted to light yellow cells. I want to any formulas are there for this application.

thanks in advance

thilag

[ashishmehra2010]

Hi Thilag,

Not sure about formula based solution; I have use UDF.

Please check the attached file.

Regards,
AM