+ Reply to Thread
Results 1 to 6 of 6

Formula to return the second to last character of a cell?

  1. 01-17-2017, 09:44 AM #1
    nobodyukno
    nobodyukno is offline
    Forum Contributor
    Join Date
    12-29-2012
    Location
    usa
    MS-Off Ver
    Excel 2016
    Posts
    325

    Formula to return the second to last character of a cell?

    Is there a formula that will return only the second to last character of a cell when the cell may have a varying length of characters?

    Thanks for the help!
    Reply With QuoteRegister To Reply
  2. 01-17-2017, 09:52 AM #2
    popipipo
    popipipo is offline
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,670

    Re: Formula to return the second to last character of a cell? 

    Please Login or Register  to view this content.
    Try this
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong
    Reply With QuoteRegister To Reply
  3. 01-17-2017, 10:14 AM #3
    davsth
    davsth is offline
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,212

    Re: Formula to return the second to last character of a cell?

    = left(right(a1,2),1)
    Reply With QuoteRegister To Reply
  4. 01-17-2017, 10:22 AM #4
    AlKey
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Formula to return the second to last character of a cell?

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

    v A B
    1 test s
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne
    Reply With QuoteRegister To Reply
  5. 01-17-2017, 10:25 AM #5
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Formula to return the second to last character of a cell?

    You may as well have a complete lexicon of solutions, so one character less...

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
  6. 01-17-2017, 10:54 AM #6
    xlnitwit
    xlnitwit is offline
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Formula to return the second to last character of a cell?

    Slightly shorter still
    =left(right(a1,2))
    Don
    Please remember to mark your thread 'Solved' when appropriate.
    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] Excel formula to return a letter character for each month
    By Jim885 in forum Excel General
    Replies: 3
    Last Post: 07-27-2015, 10:37 PM
  2. Search for character, return part of string in another cell
    By richardtenggren in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-22-2015, 04:23 AM
  3. formula that can return the text in a field starting from the 4th character
    By Davidwebb in forum Excel General
    Replies: 5
    Last Post: 09-07-2011, 09:49 PM
  4. is it possible to return image instead of character(letter) in a cell?
    By geng in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-16-2010, 12:25 PM
  5. Expressing Carriage Return Character in a Formula
    By DobieMomPA in forum Excel General
    Replies: 4
    Last Post: 06-25-2010, 02:46 PM
  6. [SOLVED] Return True if cell contains special character
    By linglc in forum Excel General
    Replies: 3
    Last Post: 07-26-2006, 03:05 AM
  7. [SOLVED] Function to return Character Position of Xth character within a string
    By Andibevan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-09-2005, 11: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