ExcelBanter - how to replace all # to blank.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how to replace all # to blank. (https://www.excelbanter.com/excel-discussion-misc-queries/168571-how-replace-all-blank.html)

John

how to replace all # to blank.

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.

Bob I

how to replace all # to blank.

R-click, Clear contents?

John wrote:

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.

All times are GMT +1. The time now is 08:51 PM.