smide
Board Regular
- Joined
- Dec 20, 2015
- Messages
- 162
- Office Version
- 2016
- Platform
- Windows
Hello.
In cell A1 (Sheet 1) I'm receiving a huge HTML code. I need to extract somehow values for 'top' and 'left' without % suffix.
for: style="top: 54%; left: 13%; I need only 54 and 13
Results should be placed in column B for top values (B2:B300) and column C for left values (C2:C300).
example.
HTML in cell A1: style="top: 69%; left: 8%; background-color: rgb(0, 255, 255); style="top: 3%; left: 61%;....
Results after macro run (Sheet 1):
<tbody>
</tbody>
In cell A1 (Sheet 1) I'm receiving a huge HTML code. I need to extract somehow values for 'top' and 'left' without % suffix.
for: style="top: 54%; left: 13%; I need only 54 and 13
Results should be placed in column B for top values (B2:B300) and column C for left values (C2:C300).
example.
HTML in cell A1: style="top: 69%; left: 8%; background-color: rgb(0, 255, 255); style="top: 3%; left: 61%;....
Results after macro run (Sheet 1):
A | B | C | |
1 | style="top: 69%; left: 8%; background-color: rgb(0, 255, 255); style="top: 3%; left: 61%;.... | Top | Left |
2 | 69 | 8 | |
3 | 3 | 61 | |
4 | .... | .... | |
5 | .... | .... |
<tbody>
</tbody>