how to replace all # to blank.

  • Thread starter Thread starter John
  • Start date Start date
J

John

In my worksheet, there are some of the box are fill with color, the arther
all are numbers. so, how to use a formula or macro to replace all numbers to
blank. and just keep the color box.
 
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 Macro to automatically go to the right of the last colored cell 0
Excel VBA 1
Display index of column headers in column A 9
Excel Numbering rows by font color, but skipping blanks 1
Keep the word (blank) out of Pivot Table? 2
find blank cell and replace with " ' " 2
MS word Find and Replace using Regex - Help required 0
Replace Cell Value with Formula 3

Back
Top