Excel 2007 : How to delete specific values from rows?

[leonlwf]

Hi all,

I have a whole list of 427 rows that have data as per below.

<option value="HUAZONGTB|Name||">HZONGTB</option>
<option value="IJZFAPP|Name to Appear|true||true|Package/First Donation||false|">Foundation</option>
<option value="NGBETHANY|Name|true|Contact No.|true|||false|">Bethany</option>

How do I delete all the values that begin with < and end with >

So that,
Row A1 will read: HZONGTB
Row A2 will read: Foundation
Row A3 will read: Bethany

Your help is appreciated. Thank you!

[MarvinP]

Hi leonlwf and welcome to the formum

Find the attached with a quick formula that will work for your above example. If it gets more complicated, I'd need to write some VBA.