I am looking for a VBA to delete All the text after the < and the < too
My Sheet has Columns A Thru J and can be anywhere from 2 to 200 rows
IE:
[TABLE="class: cms_table, width: 226"]
<tbody>[TR]
[TD="width: 226"]Mrs. Melissa <8268513.cskm>
Needs to just be
Mrs. Melissa[/TD]
[/TR]
</tbody>[/TABLE]
So I need to delete everything after the < and the < too.
<anytown, nj="" 02220="">Everything I have tried in VBA gives me errors.
Thank you</anytown,>
My Sheet has Columns A Thru J and can be anywhere from 2 to 200 rows
IE:
[TABLE="class: cms_table, width: 226"]
<tbody>[TR]
[TD="width: 226"]Mrs. Melissa <8268513.cskm>
Needs to just be
Mrs. Melissa[/TD]
[/TR]
</tbody>[/TABLE]
So I need to delete everything after the < and the < too.
<anytown, nj="" 02220="">Everything I have tried in VBA gives me errors.
Thank you</anytown,>
Last edited: