+ Reply to Thread
Results 1 to 5 of 5

Using MID with SEARCH function

  1. 01-15-2023, 10:47 AM #1
    g1terra
    g1terra is offline
    Forum Contributor
    Join Date
    06-02-2014
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    235

    Using MID with SEARCH function

    I am looking for a formula to extract the name BAKER from cell D3

    I am having an issue because BAKER is has a dynamic amount of characters. But the dynamic name is always before the " -".

    D3 = BAKER - Baker*(5)

    Any help is greatly appreciated!
    Reply With QuoteRegister To Reply
  2. 01-15-2023, 10:57 AM #2
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    31,037

    Re: Using MID with SEARCH function

    Try

    =TRIM(LEFT(D3,FIND("-",D3)-1))
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
  3. 01-15-2023, 10:58 AM #3
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,820

    Re: Using MID with SEARCH function

    How about
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 01-15-2023, 11:26 AM #4
    g1terra
    g1terra is offline
    Forum Contributor
    Join Date
    06-02-2014
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    235

    Re: Using MID with SEARCH function

    That worked great thank you!
    Reply With QuoteRegister To Reply
  5. 01-15-2023, 11:28 AM #5
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,820

    Re: Using MID with SEARCH function

    Glad to help & thanks for the feedback.
    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] Refining a search with the SEARCH Function?
    By vonsworld in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-29-2022, 06:55 AM
  2. Search Function - how to search for multiple items
    By niktodorov1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-01-2018, 10:22 PM
  3. [SOLVED] Set VBA search function to only search one row and also not show duplicates?
    By TomToms in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-05-2014, 04:00 PM
  4. How to search 2 criteria using this search function?
    By puuts in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-16-2014, 04:25 PM
  5. IF(count(search) Function not working when search from text from a cell
    By joshnathan in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-09-2013, 05:13 AM
  6. [SOLVED] Search function to search if worksheet contains specified text
    By mougiasm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-07-2013, 02:50 PM
  7. put search function into workbook that reports back adjacent cells to search criteria
    By Mike. Holmes in forum Excel General
    Replies: 1
    Last Post: 10-18-2012, 05:52 AM

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