Find and Replace cell

  • Thread starter Thread starter Lady Layla
  • Start date Start date
L

Lady Layla

Edit
Find
Enter "!a*" or "!a?" depending on how many characters can be between a and " in
box
(See Excel Help for information on wildcards)
Enter "Good" in box by Replace
Click Replace all




: I would like to find all cells beginning with a text, eg "!a" and paste the
: cells with "Good".
: Eg, cells with "!a1", "!a2" and "!a3" will be replaced with "Good"
:
: I can't find any function in Excel can do such work.
:
: Thanks in advance for your advice.
:
:
:
 
Highlight the cells you wish to change, then do Edit > Replace >........and
follow the menu.............

Vaya con Dios,
Chuck, CABGx3
 
I would like to find all cells beginning with a text, eg "!a" and paste the
cells with "Good".
Eg, cells with "!a1", "!a2" and "!a3" will be replaced with "Good"

I can't find any function in Excel can do such work.

Thanks in advance for your advice.
 
Back
Top