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.

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]HTML code[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]J. Jones[/TD]
[TD="align: center"]Sydney[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]C. Duncan[/TD]
[TD="align: center"]Toronto[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]M. Weber[/TD]
[TD="align: center"]München[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: center"]....[/TD]
[TD="align: center"]....[/TD]
[/TR]
</tbody>[/TABLE]