Can I Find one word in a formula
 

I'm sorry for my english....

I have in A1... ='[LEAO - ABRIL-2002.xls]Plan1'!$A$1
Cell content is.... example 120

Can I make one formula for find a word in this Cell (A1)....
=FIND("ABRIL";A1)

Thanks
Rod (Brazil)

Hi, Rod. What will you do when you find it?
*******************
~Anne Troy

www.OfficeArticles.com


"Rod (Brazil)" <Rod wrote in message
...
I'm sorry for my english....

I have in A1... ='[LEAO - ABRIL-2002.xls]Plan1'!$A$1
Cell content is.... example 120

Can I make one formula for find a word in this Cell (A1)....
=FIND("ABRIL";A1)

Thanks
Rod (Brazil)

Anne... for example JULHO is equal JULY and is filename part.

a formula in CELL (A1) is ='[LEAO - JULHO-2002.xls]Plan1'!$A$1 with one
result... example $120 (in this CELL A1). I need one formula for find in A1
on formula < ='[LEAO - JULHO-2002.xls]Plan1'!$A$1 for a word.... in this
case "JULHO".

Thanks



-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-

"Anne Troy" escreveu:

Hi, Rod. What will you do when you find it?
*******************
~Anne Troy

www.OfficeArticles.com


"Rod (Brazil)" <Rod wrote in message
...
I'm sorry for my english....

I have in A1... ='[LEAO - ABRIL-2002.xls]Plan1'!$A$1
Cell content is.... example 120

Can I make one formula for find a word in this Cell (A1)....
=FIND("ABRIL";A1)

Thanks
Rod (Brazil)

Hi!

The word you want to find is not actually in the cell, it's in the formula.
The value in the cell is $120.

I'm not sure how this could be done.

Biff

"Rod (Brazil)" wrote in message
...
Anne... for example JULHO is equal JULY and is filename part.

a formula in CELL (A1) is ='[LEAO - JULHO-2002.xls]Plan1'!$A$1 with one
result... example $120 (in this CELL A1). I need one formula for find in
A1
on formula < ='[LEAO - JULHO-2002.xls]Plan1'!$A$1 for a word.... in this
case "JULHO".

Thanks



-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-

"Anne Troy" escreveu:

Hi, Rod. What will you do when you find it?
*******************
~Anne Troy

www.OfficeArticles.com


"Rod (Brazil)" <Rod wrote in message
...
I'm sorry for my english....

I have in A1... ='[LEAO - ABRIL-2002.xls]Plan1'!$A$1
Cell content is.... example 120

Can I make one formula for find a word in this Cell (A1)....
=FIND("ABRIL";A1)

Thanks
Rod (Brazil)

Hi Rod

As Biff has pointed out, you cannot use FIND or SEARCH in this instance.
However, if you are just trying to locate on your sheet, every occurrence of
the word "JULHO" in formulae then
EditFind and enter JULHO in the white pane
Click Options and make sure you have Formulas selected in the Look in drop
down, and choose Find All.

This will give a list of all of the locations of cells holding JULHO in the
formula.

--
Regards
Roger Govier
"Rod (Brazil)" wrote in message
...
Anne... for example JULHO is equal JULY and is filename part.

a formula in CELL (A1) is ='[LEAO - JULHO-2002.xls]Plan1'!$A$1 with one
result... example $120 (in this CELL A1). I need one formula for find in
A1
on formula < ='[LEAO - JULHO-2002.xls]Plan1'!$A$1 for a word.... in this
case "JULHO".

Thanks



-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-

"Anne Troy" escreveu:

Hi, Rod. What will you do when you find it?
*******************
~Anne Troy

www.OfficeArticles.com


"Rod (Brazil)" <Rod wrote in message
...
I'm sorry for my english....

I have in A1... ='[LEAO - ABRIL-2002.xls]Plan1'!$A$1
Cell content is.... example 120

Can I make one formula for find a word in this Cell (A1)....
=FIND("ABRIL";A1)

Thanks
Rod (Brazil)