+ Reply to Thread
Results 1 to 4 of 4

Find text from multiple cells

  1. 10-21-2020, 03:07 AM #1
    nagesh.tvsr
    nagesh.tvsr is offline
    Forum Contributor
    Join Date
    02-15-2012
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2019
    Posts
    431

    Find text from multiple cells

    Hi,

    Need a formula to find / search specific text from multiple cells.

    An excel file attached with necessary details.

    Pl. help.

    Thanks,
    Nagesh.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-21-2020, 03:38 AM #2
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,447

    Re: Find text from multiple cells

    See attached for a possible solution
    Attached Files Attached Files
    How to paste Power Query code ( by Olly)
    Reply With QuoteRegister To Reply
  3. 10-21-2020, 03:46 AM #3
    bebo021999
    bebo021999 is offline
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,466

    Re: Find text from multiple cells

    Try:

    J2
    =OR(A2:I2)

    K2:
    =IFERROR(LOOKUP(2,1/A2:H2,B2:I2),"")
    Quang PT
    Reply With QuoteRegister To Reply
  4. 10-21-2020, 05:56 AM #4
    nagesh.tvsr
    nagesh.tvsr is offline
    Forum Contributor
    Join Date
    02-15-2012
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2019
    Posts
    431

    Re: Find text from multiple cells

    Great!

    Thanks a lot Pepe Le Mokko & Bebo.
    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. Excel formula needed to find replace multiple text from cell containing multiple text
    By tkew in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-03-2019, 10:44 AM
  2. Find Specific Text in Multiple Cells
    By jrbrugger in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 06-07-2015, 10:14 PM
  3. Find text (multiple criteria) in multiple cells, return multiple values if true/false
    By nik1703 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-26-2015, 07:29 PM
  4. [SOLVED] Lookup, find, match and list text from multiple cells
    By JSTR250 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 07-19-2014, 02:04 PM
  5. Exporting Excel Cells, to Multiple Text Files, Where each text file has multiple lines
    By psures914 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-12-2012, 04:01 PM
  6. Aargh! Help - Find cells, multiple text match
    By fallwire in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-19-2010, 05:50 AM
  7. INTRICATE PROBLEM- How to find multiple text,excluding "H", in a multiple range of cells, then replacing 0 with another number in another cell
    By Tourcat in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-08-2005, 03:06 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