deleting certain text from cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

does anyone know a way or have a macro that will delete certain text from a
sheet of cells. i need to get rid of all of 'N/A' cells in a list, and i am
not sure how to do this.
 
Assuming you have formulas that return these, select the range,hit F5, click
special and select formulas and uncheck everything but errors, click OK and
do edit>clear>all (or delete them)

Regards,

Peo Sjoblom
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel If a Cell Contains a Certain Text (From Another Table) 0
Excel Typed text appears in wrong cell 0
countif and sumif 3
Pasting cell contents into a macro 1
Excel Cannot delete empty cells/rows 4
Yes or blank, depending if value equals or exceeds value found inVLookup table. 4
Reference the same cell based on tab name 1
how to update certain text in a cell according to thecell colour 1

Back
Top