+ Reply to Thread
Results 1 to 5 of 5

delete last two digits

  1. #1
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    Excel 2010
    Posts
    2,444

    delete last two digits

    I have this

    CV088B40
    CV088B41
    CV088B42
    CV088B43


    I want this

    CV088B
    CV088B
    CV088B
    CV088B

    Formula on b1 and down , data on a1 and down

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    20,264

    Re: delete last two digits

    =left(a1,len(a1)-2)

  3. #3
    Registered User
    Join Date
    01-08-2016
    Location
    Johannesburg, South Africa
    MS-Off Ver
    2013
    Posts
    9

    Re: delete last two digits

    Paste this formula in Cell B1
    =LEFT(A1,LEN(A1)-2)

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    12,179

    Re: delete last two digits

    Or Data - Text to columns - Fixed with - Enter separator before the last two digits - Next - Select "do not import" for the second column - Finish

  5. #5
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    Excel 2010
    Posts
    2,444

    Re: delete last two digits

    Thank you all ,
    I am sorted
    I will pick the formula

+ 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. Delete everything except last 9 digits
    By McTwizle in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-06-2015, 12:22 PM
  2. Replies: 5
    Last Post: 10-25-2014, 12:35 AM
  3. Delete digits within brackets
    By ambharat in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-15-2013, 04:09 AM
  4. Delete the last 2 digits
    By cj21 in forum Excel General
    Replies: 5
    Last Post: 11-11-2008, 10:02 AM
  5. how to delete the 4 rightmost digits from a cell
    By charlene in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-29-2006, 10:15 AM
  6. Delete 4 to 5 digits from left in a cell
    By saziz in forum Excel General
    Replies: 8
    Last Post: 04-27-2006, 03:25 PM
  7. Delete first two digits in column
    By rjtees in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-17-2005, 05:25 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1