Extract Multiple Data sets within String

[uniballer]

Hello,

I 've been trying all morning to extract multiple text points out of a long text string.

Essentially, I have a number of rows with one cell that contains data like :


excel.JPG

I need to extract the info between every instance of "<div> and </div>"

If I can get the code or formula to do that I can build the loop.

Hoping you can help!

John

[FDibbins]

have you considered using text-to-columns, and using the < and > as the "break"?

[uniballer]

FDibbins,

Thanks, I guess that works, a little manual search and destroy afterwards, but seems ok.

Thanks!