Hi , Is there a way to remove variable text from a string in a cell, there will be variable rows of data that may or may not contain the W/MW values, and it's not case sensitive either. Can someone help with this please
From this
<tbody>
Voltage Switch 1/16W Ceramic Wirewound Regulator...