Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Dear All,
we have a pricing template that some turkeys decide to include text in it when filling it out. How can I find and replace ANY text that appears in the range? The variance of entered text is huge, so there is no way to find and replace specific text. We want to replace any text with a zero ("0"). Basically, we need to go from cell to cell, find an instance of text, then replace it with zero. Help would be greatly appreciated... Regards, andym |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
finding and replacing text with a blank | Excel Discussion (Misc queries) | |||
finding and replacing | Excel Worksheet Functions | |||
Finding and Replacing | Excel Discussion (Misc queries) | |||
Finding, Replacing and Cut & Paste | Excel Worksheet Functions | |||
Finding and Replacing a "?" | Excel Discussion (Misc queries) |