Pulling out the text between two different characters with DIFFERENT positions

[bretfeig]

I have a challenging one for the experts out there.

I have the following in Column B:

<p class="tagline">President</p>
<h3 class="title">John Merrrrino</h3>
<p class="tagline">Managing Partner</p>
<h3 class="title">Nick Smith</h3>
<p class="tagline">Managing Director</p>
<h3 class="title">Matt smith</h3>
<p class="tagline">Managing Director / Chief of Staff</p>

What I need to do is pulling out the text between > and < (title and name)

Here is the difficulty

I need it to find the SECOND occurrence of the ">" and the first occurrence of "<"

The outcome should be:

President
Jon Merrino
Managing Partner
Nick Smith
etc


Secondary challenge is that the strings aren't the same length because </p> and </h3> are different length.

Thoughts?

[Tony Valko]

Try this...

Data Range

	B	C
1	<p class="tagline">President</p>	President
2	<h3 class="title">John Merrrrino</h3>	John Merrrrino
3	<p class="tagline">Managing Partner</p>	Managing Partner
4	<h3 class="title">Nick Smith</h3>	Nick Smith
5	<p class="tagline">Managing Director</p>	Managing Director
6	<h3 class="title">Matt smith</h3>	Matt smith
7	<p class="tagline">Managing Director / Chief of Staff</p>	Managing Director / Chief of Staff

This formula entered in C1 and copied down:

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

[José Augusto]

Or try
=MID(B18,FIND(">",B1)+1,FIND("<",B1,FIND(">",B1))-FIND(">",B1)-1)

[bretfeig]

That's perfect. I was overthinking that completely

Thank you! Both of you

[Tony Valko]

You're welcome. We appreciate the feedback!

If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

[bretfeig]

Curious as to why either formula works perfecting and what the differences are.

Thanks Jose & Tony