Home

Deleting select characters from a cell

%3CLINGO-SUB%20id%3D%22lingo-sub-304769%22%20slang%3D%22en-US%22%3EDeleting%20select%20characters%20from%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-304769%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20spreadsheet%20that%20includes%20some%20html%20code%20characters%20that%20I%20want%20to%20find%20and%20delete.%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20a%20sample%20cell%3A%26nbsp%3B%3CSTRONG%3E%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EBezel%20Set%20Black%20Onyx%20in%20Rhodium%20with%20Chain%3C%2FP%3E%3CP%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20delete%20the%20%3CSTRONG%3E%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3Eand%20%3CSTRONG%3E%3C%2FSTRONG%3E%3C%2FP%3Efrom%20the%20cell%20contents%20and%20keep%20the%20rest.%3CP%3E%3C%2FP%3E%3CP%3EI%20tried%20the%20find%2C%20find%20and%20replace...%20but%20I%20need%20to%20isolate%20the%20code%20elements%2C%20including%20the%20special%20characters%20%26lt%3B%26gt%3B.%3C%2FP%3E%3CP%3EAny%20suggestions%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-304769%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-304789%22%20slang%3D%22en-US%22%3ERe%3A%20Deleting%20select%20characters%20from%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-304789%22%20slang%3D%22en-US%22%3E%3CP%3EYes%2C%20it%20seems%20to%20be%20working%20now.%20I%20had%20tried%20the%20replace%20option%20earlier%20and%20it%20wasn't%20allowing%20me%20to%20replace%20with%20an%20empty%20space.%20Working%20now%20though!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20reply.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-304781%22%20slang%3D%22en-US%22%3ERe%3A%20Deleting%20select%20characters%20from%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-304781%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Michael%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20Ctrl%2BH%20on%26nbsp%3B%3C%2FP%3E%20and%20Replace%20All%2C%20same%20on%20%3CP%3E%2C%20does%20that%20work%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
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

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.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies