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.