Hi Guys,
I have a problem and need a solution.
I have multiple lines in my spreadsheet where cells have alot of HTML (this is an HTML Template for eBay) What i need to do is remove all the HTML from the cell so that just the plain text is left.
I've tried doing a find and replace using <*> but this doesn't remove everything, there's always bits of HTML left over.
I need something that i can store in my Personal.xlsb so i ca use on any workbook as i have this alot.
Can somebody please help me. Also i could do we having it so if the HTML specifies the text is on the next line down the format stays.
Hope this makes sense.
Thanks in advance.
Bookmarks