Forum Discussion

Michael Lovice's avatar
Michael Lovice
Copper Contributor
Dec 20, 2018

Deleting select characters from a cell

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?

excel

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Dec 20, 2018

    Hi Michael,

     

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

    • Michael Lovice's avatar
      Michael Lovice
      Copper Contributor
      Dec 20, 2018

      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.

Resources