Deleting select characters from a cell

Copper Contributor

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?

2 Replies

Hi Michael,

 

If you Ctrl+H on </p> and Replace All, same on <p>, does that work?

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.