+ Reply to Thread
Results 1 to 9 of 9

Excel formula for search from sentence

  1. 07-03-2023, 09:17 PM #1
    harignz
    harignz is offline
    Registered User
    Join Date
    07-25-2011
    Location
    Sydney
    MS-Off Ver
    Microsoft 365
    Posts
    20

    Excel formula for search from sentence

    Our customers use all kind of payment reference when they make payment. Sometime they use company number, name and invoice number. The team need to check different approach to find a customer number. so I need the formula to check if it's invoice number then check specific location and if company number then look a different range and put the information. Once I have Invoice number separated from payment reference then I can VLOOKUP for customer

    I need to find a word from the sentence in cell C2 from the range from column G. Once a specific word is found from range column G, update the result in cell D2.

    Attached is a sample file.

    appreciate for your help in advance.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-03-2023, 09:30 PM #2
    HansDouwe
    HansDouwe is offline
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,466

    Re: Excel formula for search from sentence

    I need to find a word from the sentence in cell C2 from the range from column G
    C2 and column G are empty??
    And I don't see expected results of the formula, please add manually the expected results of the formula to your workbook.
    Reply With QuoteRegister To Reply
  3. 07-03-2023, 10:24 PM #3
    harignz
    harignz is offline
    Registered User
    Join Date
    07-25-2011
    Location
    Sydney
    MS-Off Ver
    Microsoft 365
    Posts
    20

    Re: Excel formula for search from sentence

    Thanks for the quick response.

    Please find the updated worksheet with the expected result in column C
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 07-03-2023, 10:51 PM #4
    HansDouwe
    HansDouwe is offline
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,466

    Re: Excel formula for search from sentence

    Please try in C2 and copy down:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 07-03-2023, 10:56 PM #5
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Excel formula for search from sentence

    your attachment from post#3 has nothing to do with your description from post#1
    Reply With QuoteRegister To Reply
  6. 07-03-2023, 11:28 PM #6
    harignz
    harignz is offline
    Registered User
    Join Date
    07-25-2011
    Location
    Sydney
    MS-Off Ver
    Microsoft 365
    Posts
    20

    Re: Excel formula for search from sentence

    Thaks for the solution. It's working fine so I take care from here.
    Reply With QuoteRegister To Reply
  7. 07-03-2023, 11:29 PM #7
    harignz
    harignz is offline
    Registered User
    Join Date
    07-25-2011
    Location
    Sydney
    MS-Off Ver
    Microsoft 365
    Posts
    20

    Re: Excel formula for search from sentence

    Thanks for your help. I can work from here.
    Reply With QuoteRegister To Reply
  8. 07-03-2023, 11:42 PM #8
    HansDouwe
    HansDouwe is offline
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,466

    Re: Excel formula for search from sentence

    Thank you for your feedback and rep Glad to have helped from the Netherlands.
    Reply With QuoteRegister To Reply
  9. 07-04-2023, 12:18 AM #9
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,371

    Re: Excel formula for search from sentence

    If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You should do this for ALL threads you have started here that have been solved. Thanks.

    Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    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. [SOLVED] search a word form a list, in a sentence
    By danbitton in forum Excel General
    Replies: 5
    Last Post: 05-24-2022, 08:25 AM
  2. How to search keywords in a sentence
    By silmiya in forum Excel Formulas & Functions
    Replies: 30
    Last Post: 02-12-2021, 12:52 PM
  3. [SOLVED] Search a number in a sentence
    By carlito.salera in forum Excel Formulas & Functions
    Replies: 33
    Last Post: 05-15-2020, 07:19 PM
  4. [SOLVED] Excel formula to convert sentence in number
    By Abdur_rahman in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 06-28-2019, 07:07 AM
  5. [SOLVED] search button with reply sentence
    By julieta in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-17-2014, 05:24 AM
  6. [SOLVED] Search for a word from a sentence....
    By raghuprasad.999 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-26-2012, 10:54 PM
  7. Search for a string in a sentence/ phrase
    By DataMcQueen917 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-09-2011, 06:06 PM

Tags for this Thread

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