Can I Find one word in a formula

[Guest]

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 Troy]

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

www.OfficeArticles.com

 

[Guest]

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

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)

 

[Biff]

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

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

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)

 

[Roger Govier]

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
Edit>Find 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

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

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)