Hi everyone - does anyone know how to remove HTML tags from a spreadsheet? I do a database query in excel on work orders that we've created in a separate system, however the comments made on the work order come through into my spreadsheet with HTML tags. Is there some code I can use that will remove these tags?

I don't want to use Find and Replace as we do this every month on a number of spreadsheets, therefore it would be much easier if there was coding set up on my template spreadsheet that would do this automatically.


Thanks
Emma