Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
My husband has 400 different formulas to change. Is it possible to use the
find and replace feature with that? |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I've done that often and it's pretty easy -- especially if you want to make
the same change in each one. You're right -- just use the Find-and-Replace (ctrl-H) feature. 1) Select the cells you want to change. 2) Press Ctrl-H. 3) Type in the text you want to change from. 4) Type in the text you want to change to. At this point, I'd replace a couple of them one-at-a-time just to make sure you're getting what you want. Then replace all. "Tennfour" wrote: My husband has 400 different formulas to change. Is it possible to use the find and replace feature with that? |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
On Mon, 13 Feb 2006 12:37:38 -0800, "Tennfour"
wrote: My husband has 400 different formulas to change. Is it possible to use the find and replace feature with that? Yes --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|