+ Reply to Thread
Results 1 to 8 of 8

Variation of the LEFT function

  1. 09-18-2015, 03:09 PM #1
    Patish
    Patish is offline
    Forum Contributor
    Join Date
    09-19-2003
    Posts
    226

    Variation of the LEFT function

    Hi Y'all

    Looking for a variation of the LEFT function

    I need to isolate from I161-0000, for example, 161. Using the LEFT function or the LEFT in conjunction with the FIND function I can only isolate it to I161.

    Can you help?

    Thanks
    Patish
    Reply With QuoteRegister To Reply
  2. 09-18-2015, 03:28 PM #2
    MrShorty
    MrShorty is offline
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,829

    Re: Variation of the LEFT function

    It would appear to me that you want the =MID() function https://support.office.com/en-us/art...8-4ecb12433028
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.
    Reply With QuoteRegister To Reply
  3. 09-18-2015, 03:29 PM #3
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Variation of the LEFT function

    What is special about 161? What are you looking for?

    If you simply want the three characters starting on the second character, then you want
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]
    Reply With QuoteRegister To Reply
  4. 09-18-2015, 03:38 PM #4
    Norie
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Variation of the LEFT function

    Do you want everything before the '-'?

    Can you post more examples?
    Last edited by Norie; 09-18-2015 at 03:41 PM.
    If posting code please use code tags, see here.
    Reply With QuoteRegister To Reply
  5. 09-18-2015, 03:49 PM #5
    Patish
    Patish is offline
    Forum Contributor
    Join Date
    09-19-2003
    Posts
    226

    Re: Variation of the LEFT function

    Three digits between - and I.

    All the numbers are in the following format ixxx-xxxx where x are digits.
    Reply With QuoteRegister To Reply
  6. 09-18-2015, 04:11 PM #6
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Variation of the LEFT function

    Then my formula will work.
    Reply With QuoteRegister To Reply
  7. 09-18-2015, 04:12 PM #7
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,938

    Re: Variation of the LEFT function

    Can you provide more samples and show your expected outcome?
    Maybe =mid(a1,2,3) (which is exactly what 6string gave)
    If you need it to be a value, instead of text...
    =--mid(a1,2,3)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  8. 09-18-2015, 06:05 PM #8
    Patish
    Patish is offline
    Forum Contributor
    Join Date
    09-19-2003
    Posts
    226

    Re: Variation of the LEFT function

    Many thanks for your assistance.

    Patish
    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] IF Function referencing IsNumber, Match, Left function on separate sheets
    By Touch9713 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-12-2013, 10:09 PM
  2. variation on VLookup or Index function
    By dododave in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 09-25-2012, 02:05 PM
  3. My IF function is not recognizing the results of my LEFT function.
    By tblasko in forum Excel General
    Replies: 2
    Last Post: 03-26-2012, 10:05 AM
  4. Using Countif function or variation to count instances of negative $ values in rows
    By mgerada in forum Excel General
    Replies: 2
    Last Post: 01-05-2012, 08:36 AM
  5. Variation of the lookup function
    By lerlan1 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-26-2010, 01:52 PM
  6. HOW DO I NEST THE VLOOKUP FUNCTION WITH THE LEFT FUNCTION
    By CHAIM in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  7. [SOLVED] HOW DO I NEST THE VLOOKUP FUNCTION WITH THE LEFT FUNCTION
    By CHAIM in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 AM
  8. HOW DO I NEST THE VLOOKUP FUNCTION WITH THE LEFT FUNCTION
    By CHAIM in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 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