+ Reply to Thread
Results 1 to 5 of 5

Extract Values using Left, Right, Mid, or Substitute Function

  1. 07-08-2021, 02:13 PM #1
    bjnockle
    bjnockle is offline
    Forum Contributor
    Join Date
    02-06-2013
    Location
    Maryland
    MS-Off Ver
    Excel 2010
    Posts
    1,000

    Extract Values using Left, Right, Mid, or Substitute Function

    Looking for formula to extract values using Left, Right, Mid, or Substitute Function. Desired outcome in B2:C5. See sample file.

    Thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-08-2021, 02:19 PM #2
    JohnTopley
    JohnTopley is online now
    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
    28,169

    Re: Extract Values using Left, Right, Mid, or Substitute Function

    This ??

    in C2

    =TRIM(LEFT($A2,FIND("-",$A2)-2))

    in D2

    =TRIM(LEFT($A2,FIND(",",$A2)-1))
    Last edited by JohnTopley; 07-08-2021 at 02:24 PM.
    Reply With QuoteRegister To Reply
  3. 07-08-2021, 02:28 PM #3
    tanasedn
    tanasedn is offline
    Valued Forum Contributor
    Join Date
    06-23-2021
    Location
    Romania
    MS-Off Ver
    2021, 365 v 2208
    Posts
    722

    Re: Extract Values using Left, Right, Mid, or Substitute Function

    In C2
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    In D2
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Diana Tanase

    If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !
    Reply With QuoteRegister To Reply
  4. 07-08-2021, 02:45 PM #4
    bjnockle
    bjnockle is offline
    Forum Contributor
    Join Date
    02-06-2013
    Location
    Maryland
    MS-Off Ver
    Excel 2010
    Posts
    1,000

    Re: Extract Values using Left, Right, Mid, or Substitute Function

    tanasedn: Outstanding solution. Thank you.
    Reply With QuoteRegister To Reply
  5. 07-08-2021, 02:46 PM #5
    bjnockle
    bjnockle is offline
    Forum Contributor
    Join Date
    02-06-2013
    Location
    Maryland
    MS-Off Ver
    Excel 2010
    Posts
    1,000

    Re: Extract Values using Left, Right, Mid, or Substitute Function

    JohnTopley: Great solution. Thanks
    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. Separate Values into Column B & C Using Right, Left, Mid, Search, or Substitute function
    By bjnockle in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-06-2021, 03:33 PM
  2. [SOLVED] Left, Right, Mid, or Substitute function to separate values into desired columns
    By bjnockle in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-02-2021, 10:40 AM
  3. [SOLVED] Extract Values Using Left, Right, or Mid Function
    By bjnockle in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 02-22-2021, 09:39 AM
  4. [SOLVED] Extract Values Using Left, Right, or Mid Function
    By bjnockle in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-08-2021, 07:43 PM
  5. [SOLVED] Extract Values Using Left, Right, or Mid Function
    By bjnockle in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-07-2021, 07:50 PM
  6. Right function, Left function, Mid function to extract values in column A
    By bjnockle in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 06-14-2020, 03:14 PM
  7. [SOLVED] Extract texts from cell using SUBSTITUTE, RIGHT, LEFT, or MID FUNCTION
    By bjnockle in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-20-2020, 10:12 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