help me

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

navigator - 30 Jun 2004 10:09 GMT

Good day to all, my question is: exists one way in order to moderniz
more formulas at the same time? Example: we leave from the formula:
se([pippo.xls]gennaio!$H$4="SI";"X";"") it is possible to obviousl
replace the word January with February etc at the same time on othe
formulas that contain the same word? Thanks:confused

--
Message posted from http://www.ExcelForum.com

Reply to this Message

Rudolf Sommer - 30 Jun 2004 13:48 GMT

navigator < schrieb:

> Good day to all, my question is: exists one way in order to modernize
> more formulas at the same time? Example: we leave from the formula: =
[quoted text clipped - 4 lines]
> ---
> Message posted from http://www.ExcelForum.com/

Navigator,

most people here would appreciate it if you would use your real name. It
swould also help if you would tell us with which version of Excel you
are working.
Your problem can easily be solved in using the find and replace function
in Excel. As my command of the Italian language is limited and I am
working with a German version of Excel, I have no idea how this is
worded in Italian. The function is avaliable through the menu (Edit -
Search & replace)
HTH
Ruedi

Signature

Ruedi Sommer *rudolf"+"."+"sommer"&at&"bluewin.ch
Antworten nur an die NG - bitte keine e-mails
Answers to the NG only - no e-amisl please

Reply to this Message

Don Guillett - 30 Jun 2004 14:00 GMT

You will get more help if:
1. You use meaningful subject lines
2. This is an english forum so difficult for most to understand your formula
3. Use a real name

I think the answer to your question may be found in HELP index for INDIRECT.
Or, use find/replace from the edit toolbar

Signature

Don Guillett
SalesAid Software
donaldb@281.com

Reply to this Message