Find and Replace through functions?

A

Aaron

Is it possible to "Find and Replace" through worksheet functions rather than menu items? I would also need to do this just for particular cells. For example, let's say I have A5:C7 filled with the following information

12 9 1
11 8 1
12 8 1

What I want to do is find and replace '8' in those cells with 'W'. The way I want to do this is to have a validated list cell with the potential numbers (12,9,15,11,8) that a person can select from. Once they select a number from that list, I want the "find and replace" to initiate based on that selection

Challenging I know, and the easy answer is to go to VBA but I have made it this far without (which is good as I am far from proficient in it)

Any ideas?
 
D

Don Guillett

Maybe it's time to start becoming proficient. Try recording a macro while
doing the menu items method. Then, clean it up and/or come on back to us for
more help.

--
Don Guillett
SalesAid Software
[email protected]
Aaron said:
Is it possible to "Find and Replace" through worksheet functions rather
Click to expand...
than menu items? I would also need to do this just for particular cells.
For example, let's say I have A5:C7 filled with the following information:
12 9 15
11 8 15
12 8 15

What I want to do is find and replace '8' in those cells with 'W'. The
Click to expand...
way I want to do this is to have a validated list cell with the potential
numbers (12,9,15,11,8) that a person can select from. Once they select a
number from that list, I want the "find and replace" to initiate based on
that selection.
Challenging I know, and the easy answer is to go to VBA but I have made it
Click to expand...
this far without (which is good as I am far from proficient in it).
 
Top