+ Reply to Thread
Results 1 to 5 of 5

delete last two digits

  1. 01-08-2016, 07:06 AM #1
    makinmomb
    makinmomb is offline
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    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
    Reply With QuoteRegister To Reply
  2. 01-08-2016, 07:09 AM #2
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,178

    Re: delete last two digits

    =left(a1,len(a1)-2)
    Reply With QuoteRegister To Reply
  3. 01-08-2016, 07:10 AM #3
    jwmanners
    jwmanners is offline
    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)
    Reply With QuoteRegister To Reply
  4. 01-08-2016, 07:17 AM #4
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    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
    How to paste Power Query code ( by Olly)
    Reply With QuoteRegister To Reply
  5. 01-08-2016, 07:19 AM #5
    makinmomb
    makinmomb is offline
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: delete last two digits

    Thank you all ,
    I am sorted
    I will pick the formula
    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. Delete everything except last 9 digits
    By McTwizle in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-06-2015, 12:22 PM
  2. [SOLVED] How to delete the digits and the following spaces in the beginning of a string
    By sumesh56 in forum Excel General
    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. [SOLVED] 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1