Home

Deleting specific characters from cells

Highlighted
Michael Lovice
Occasional 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
Highlighted
Yes, sorry
Related Conversations
Linking Adjacent Rows
ashwinash112 in Excel on
1 Replies