+ Reply to Thread
Results 1 to 3 of 3

Extract only the second and third characters

  1. #1
    Registered User
    Join Date
    10-11-2017
    Location
    San Antonio, TX
    MS-Off Ver
    7
    Posts
    41

    Extract only the second and third characters

    Hello and Thank you for your help
    Looking for formula to extract only the second and third characters from cell B1 which end user types or paste 17 characters into

    And formula to extract third character from cell B2 which end user types or paste 6 characters into

    Thank you

  2. #2
    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: Extract only the second and third characters

    Second and third from B1
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Third only from B2
    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]

  3. #3
    Registered User
    Join Date
    10-11-2017
    Location
    San Antonio, TX
    MS-Off Ver
    7
    Posts
    41

    Re: Extract only the second and third characters

    Thank you, that worked

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Extract characters inside a sting between specific characters
    By augr in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-12-2021, 07:04 PM
  2. [SOLVED] Vlookup to extract last five characters or include only first 5 characters
    By Michael Lerena in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-10-2017, 04:53 PM
  3. Extract characters
    By Ravana in forum Excel General
    Replies: 5
    Last Post: 02-14-2015, 06:21 AM
  4. [SOLVED] Extract left characters from string with exception of 2 right characters
    By sweetkel23 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-16-2012, 10:45 PM
  5. Extract 8 characters out of a URL
    By SRd240sx in forum Excel General
    Replies: 20
    Last Post: 01-11-2011, 03:59 AM
  6. [SOLVED] Extract the first few characters
    By MC_blur in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-13-2006, 01:20 PM
  7. HOW DO I EXTRACT ALL CHARACTERS AFTER 5 CHARACTERS ON LEFT
    By GRYSYF in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-12-2005, 07: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1