+ Reply to Thread
Results 1 to 3 of 3

Formula to remove first two character is second character is a number.

  1. #1
    Registered User
    Join Date
    04-25-2012
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    91

    Formula to remove first two character is second character is a number.

    Hello,

    I am looking for an "If" statement formula which can take a cell and judge whether the second character is a number and then remove the first two characters if it is not number. If it is a number then nothing will be done.

    Exaple for the cell to judge:

    2A25KL-AAACB --> (this would remove first two characters)

    25KL-AAACB --> (this would do nothing)

    Any help would be greatly appreciated.

    Thanks!

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Formula to remove first two character is second character is a number.

    Try

    =IF(ISNUMBER(MID(A1,2,1)*1),A1,RIGHT(A1,LEN(A1)-2))
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    04-25-2012
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    91

    Re: Formula to remove first two character is second character is a number.

    Thanks! I was unaware of the ISNUMBER function and MID. So this is perfect.

    Thanks you so much!

    I will mark a solved.

+ 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] Remove first character in a cell when the second character is blank
    By eastdallasguy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-01-2013, 03:11 PM
  2. Replies: 5
    Last Post: 04-22-2013, 02:28 PM
  3. Replies: 3
    Last Post: 11-20-2012, 10:03 PM
  4. remove cr character from a + number and change number to - 159cr
    By Cr character on numbers in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-10-2006, 06:40 PM
  5. Replies: 3
    Last Post: 01-31-2006, 04:30 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