+ Reply to Thread
Results 1 to 7 of 7

Formula to find text in cell

  1. #1
    Registered User
    Join Date
    02-25-2014
    Location
    Auzzie
    MS-Off Ver
    Excel 2010
    Posts
    49

    Formula to find text in cell

    HI Everyone

    I have been searching for a solution but I cant find one.

    What I have in a sheet is the following

    A1 0 B1 0 C Dog, so the formula will bring back Dog or could be a1 Dog b1 0 c1 0, the formula would bring back dog again. Only one of the cells will ever have text the other two will always be 0

    Thanks for any help

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Formula to find text in cell

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Formula to find text in cell

    What if A1 has Dog and B1 has Cat..

    What should be the output?
    Cheers!
    Deep Dave

  4. #4
    Registered User
    Join Date
    02-25-2014
    Location
    Auzzie
    MS-Off Ver
    Excel 2010
    Posts
    49

    Re: Formula to find text in cell

    Thanks Mehmetcik, works perfect. Annoys me, I wasted so much time trying different ways and you gave me a simple solution in 2mins. Thanks mate

  5. #5
    Registered User
    Join Date
    02-25-2014
    Location
    Auzzie
    MS-Off Ver
    Excel 2010
    Posts
    49

    Re: Formula to find text in cell

    NeedforExcel only one of the cells will have a word in. the other two will always be a 0

  6. #6
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Formula to find text in cell

    Quote Originally Posted by top_dog View Post
    NeedforExcel only one of the cells will have a word in. the other two will always be a 0
    I am sorry, you had already mentioned it, and I missed it somehow..

    I believe you already have your answer..

    Cheers!

  7. #7
    Registered User
    Join Date
    02-25-2014
    Location
    Auzzie
    MS-Off Ver
    Excel 2010
    Posts
    49

    Re: Formula to find text in cell

    Thanks N4E

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Cannot find text data within cell containing VLOOKUP formula
    By pvor in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-23-2015, 02:39 PM
  2. Formula to find text in cell with alt + enter
    By NS4Excel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-04-2015, 06:24 PM
  3. [SOLVED] Formula Find Specified Text show contents of the cell below
    By keen2xl in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-21-2014, 04:43 PM
  4. Formula to find and return text string within a cell full of text strings
    By LightingPop in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-03-2013, 11:45 PM
  5. Find max when cell contains =text formula
    By jw01 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-13-2013, 04:22 PM
  6. [SOLVED] Trying to find a formula to find a random $ amount in a text in a cell
    By Miki1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-28-2013, 10:13 PM
  7. formula to find text and use the value in its adjacent cell???
    By its_jess_meeh in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-06-2011, 09:07 PM

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