Results 1 to 3 of 3

Thread: Search specific word from paragraph and return the same value

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Acolyte mihir777's Avatar
    Join Date
    May 2016
    Posts
    23
    Articles
    0
    Excel Version
    2016

    Search specific word from paragraph and return the same value

    hello,

    example is as below

    Formula used =IF(SUMPRODUCT(--(NOT(ISERR(SEARCH($H$3:$H$5,E3)))))>0,"1","")
    Current Result using formula
    content result specific text
    abc rohan fcv ssssb fff ssss eeeel fffll 1 raj
    abc rbl fcv ssssb fff meet eeeel fffll 1 rohan
    raj ddd vvd ssdsd fdfee sxx 1 meet


    expected result
    content result specific text
    abc rohan fcv ssssb fff ssss eeeel fffll rohan raj
    abc rbl fcv ssssb fff meet eeeel fffll meet rohan
    raj ddd vvd ssdsd fdfee sxx raj meet
    Attached Files Attached Files

Posting Permissions

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