Hi, I have downloaded the data in the table, and it came with the percent numbers (in grey) stuck to the volume numbers (in black). I have 400 rows like this and need two columns - one for volume numbers and the other for percent numbers. Because I have various numbers of characters in each row that need to be separated, I cannot use a LEFT/RIGHT formula. Is there an alternative way to separate these? two
Many thanks!
A_K
<colgroup><col><col></colgroup><tbody>
</tbody>
Many thanks!
A_K
Product1 | 39(1%) |
Product2 | 398(10.16%) |
Product3 | 432(11.02%) |
Product4 | 2756(70.3%) |
Product5 | 456(11.64%) |
Product6 | 457(11.66%) |
Product7 | 482(12.3%) |
Product8 | 328(8.37%) |
Product9 | 2884(73.6%) |
<colgroup><col><col></colgroup><tbody>
</tbody>