+ Reply to Thread
Results 1 to 5 of 5

how to search for text within the output of a formula?

  1. 07-05-2018, 01:34 AM #1
    tukae
    tukae is offline
    Registered User
    Join Date
    12-03-2007
    Location
    Singapore
    MS-Off Ver
    Professional Plus 2010
    Posts
    45

    how to search for text within the output of a formula?

    ss2.png

    the formulas in column C are:

    =A1&B1
    =A2&B2
    =A3&B3

    how do i search and find the output of the formulas in column C e.g. find "unreal"
    Reply With QuoteRegister To Reply
  2. 07-05-2018, 02:43 AM #2
    BadlySpelledBuoy
    BadlySpelledBuoy is offline
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,940

    Re: how to search for text within the output of a formula?

    What do you mean by "find"?

    BSB
    Reply With QuoteRegister To Reply
  3. 07-05-2018, 03:46 AM #3
    mohan.r1980
    mohan.r1980 is offline
    Valued Forum Contributor mohan.r1980's Avatar
    Join Date
    09-18-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010 (windows7)
    Posts
    729

    Re: how to search for text within the output of a formula?

    Press CTRL + F
    go to option
    Doc1.docx
    change the setting of 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 07-05-2018, 04:01 AM #4
    tukae
    tukae is offline
    Registered User
    Join Date
    12-03-2007
    Location
    Singapore
    MS-Off Ver
    Professional Plus 2010
    Posts
    45

    Re: how to search for text within the output of a formula?

    Quote Originally Posted by mohan.r1980 View Post
    Press CTRL + F
    go to option
    Attachment 580615
    change the setting of 
    Please Login or Register  to view this content.
    thank you. that did it.
    Reply With QuoteRegister To Reply
  5. 07-05-2018, 04:14 AM #5
    mohan.r1980
    mohan.r1980 is offline
    Valued Forum Contributor mohan.r1980's Avatar
    Join Date
    09-18-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010 (windows7)
    Posts
    729

    Re: how to search for text within the output of a formula?

    your welcome
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Help with Search Text Criteria and Output Corresponding Text
    By AL_Tambooka in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-27-2017, 03:48 PM
  2. Loop formula to search through range to get expected output
    By raj2989 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-17-2014, 09:15 AM
  3. Search cell text and output different values based on result in another cell
    By tbarn1980 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-14-2013, 09:54 PM
  4. Formula to search column for match and output date in corresponding row
    By bpartin13 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-22-2013, 12:52 AM
  5. [SOLVED] Search a text in an array and gives a corresponding output.
    By krash297 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-30-2013, 07:37 AM
  6. Output text to cells if search result is positive
    By pylauzier in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-29-2011, 12:57 PM
  7. add text to end of formula output
    By mgdarkman in forum Excel General
    Replies: 2
    Last Post: 12-08-2005, 11:55 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1