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)
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 (Brazil)@discussions.microsoft.com> wrote in message
news:E6669F26-2608-4DBE-8410-34E658F10772@microsoft.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)
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 (Brazil)@discussions.microsoft.com> wrote in message
> news:E6669F26-2608-4DBE-8410-34E658F10772@microsoft.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)
>
>
>
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)" <RodBrazil@discussions.microsoft.com> wrote in message
news:32188FA3-0558-44A6-A1CD-59CADD4C7DB9@microsoft.com...
> 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 (Brazil)@discussions.microsoft.com> wrote in message
>> news:E6669F26-2608-4DBE-8410-34E658F10772@microsoft.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)
>>
>>
>>
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
"Rod (Brazil)" <RodBrazil@discussions.microsoft.com> wrote in message
news:32188FA3-0558-44A6-A1CD-59CADD4C7DB9@microsoft.com...
> 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 (Brazil)@discussions.microsoft.com> wrote in message
>> news:E6669F26-2608-4DBE-8410-34E658F10772@microsoft.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)
>>
>>
>>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks