Dec 20 2018 06:58 AM
I have a spreadsheet that includes some html code characters that I want to find and delete.
Here's a sample cell: <p>Bezel Set Black Onyx in Rhodium with Chain</p>
I want to delete the <p> and </p> from the cell contents and keep the rest.
I tried the find, find and replace... but I need to isolate the code elements, including the special characters <>.
Any suggestions?
Dec 20 2018 07:18 AM
Hi Michael,
If you Ctrl+H on </p> and Replace All, same on <p>, does that work?
Dec 20 2018 07:33 AM
Yes, it seems to be working now. I had tried the replace option earlier and it wasn't allowing me to replace with an empty space. Working now though!
Thanks for the reply.