+ Reply to Thread
Results 1 to 5 of 5

Can I Find one word in a formula

  1. #1
    Rod (Brazil)
    Guest

    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)

  2. #2
    Anne Troy
    Guest

    Re: Can I Find one word in a formula

    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:[email protected]...
    > 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)




  3. #3
    Rod (Brazil)
    Guest

    Re: Can I Find one word in a formula

    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:[email protected]...
    > > 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)

    >
    >
    >


  4. #4
    Biff
    Guest

    Re: Can I Find one word in a formula

    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)" <[email protected]> wrote in message
    news:[email protected]...
    > 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:[email protected]...
    >> > 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)

    >>
    >>
    >>




  5. #5
    Roger Govier
    Guest

    Re: Can I Find one word in a formula

    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)" <[email protected]> wrote in message
    news:[email protected]...
    > 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:[email protected]...
    >> > 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)

    >>
    >>
    >>




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1