Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tennfour
 
Posts: n/a
Default Can the "Find and Replace" feature be used in Formulas somehow?

My husband has 400 different formulas to change. Is it possible to use the
find and replace feature with that?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pdberger
 
Posts: n/a
Default Can the "Find and Replace" feature be used in Formulas somehow?

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld
 
Posts: n/a
Default Can the "Find and Replace" feature be used in Formulas somehow?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 07:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"