Extracting Specific Text

[jdh3]

Hi there.

So I have a column full of cells that look like this.

Beautifully muted shimmering trim tied in a doubled bow adorn a 3/8" matching headband. Colors: Rose, Black, Gold (carrot)img src="/PDGimages/Women-Shimmer-Bow-Swatch.jpg" alt="swatch" /(carrot)

What I need to do is extract the (carrot)img src="... /(carrot) from each paragraph and move it to another column. So A1 would have the entire paragraph, and B1 would only have the "img src" code from A1...and so on.

Does someone here have a formula I can use?

Much thanks for your help.

Jamie

 

[iliace]

If there's only one tag per line, you can do something like

=MID(A1, FIND("<", A1)+1, FIND(">", A1)-FIND("<", A1)-1)