smide
Board Regular
- Joined
- Dec 20, 2015
- Messages
- 162
- Office Version
- 2016
- Platform
- Windows
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:
Part of code for towns is also always the same:
Basically I need to extract somehow only part between
and
for Name and part between
and
for Town.
I'm using excel 2007.
example.
<tbody>
</tbody>
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:
HTML:
<div class="customName--1gBeC">J. Jones</div>
Part of code for towns is also always the same:
HTML:
<td class="search-results-table-column-town ">Sydney</td>
Basically I need to extract somehow only part between
HTML:
1gBeC">
HTML:
</div>
HTML:
column-town ">
HTML:
</td>
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>
Last edited: