VBA to extract part of HTML code

[smide]

Hello.


In cell A1 I'm receiving Customer names an their home town in form of huge HTML code.
I need to extract Customer names in column A (A3:A600) and their home towns in column B (B3:B600).

Part of HTML code for names is always the same:

<div class="customName--1gBeC">J. Jones</div>

Part of code for towns is also always the same:

<td class="search-results-table-column-town ">Sydney</td>

Basically I need to extract somehow only part between

1gBeC">

and

</div>

for Name and part between

column-town ">

and

</td>

for Town.


I'm using excel 2007.

example.

	A	B
1	HTML code
2
3	J. Jones	Sydney
4	C. Duncan	Toronto
5	M. Weber	München
6	....	....

<tbody>
</tbody>