Assuming your data starts with A1 and apply the below formula in b1 and drag down (select B1 to B11 and CTRL + D)
=RIGHT(A1,2)
Top answer 1 of 2
1
Assuming your data starts with A1 and apply the below formula in b1 and drag down (select B1 to B11 and CTRL + D)
=RIGHT(A1,2)
2 of 2
0
This Should do it.
=LEFT(A1,LEN(A1)-2)
What we do in the formula is ask for the Left side of the text from the total string lenght minus two, which removes the 2 last characters in the string.
MrExcel
mrexcel.com › forums › question forums › excel questions
Taking JUST last two digits off a number? | MrExcel Message Board
August 17, 2010 - Hello sice, welcome to MrExcel If data is in A2 downwards try this formula in B2 copied down =LEFT(A2,LEN(A2)-2)
formula remove last 2 digits
Is there a formula that will remove the last 2 digits from a field string which are not the same. For example Old New 12345678 123456 1234 12 12345 123 Regards More on mrexcel.com
2
0
November 3, 2003Remove last 3 digits
=LEFT(A1,LEN(A1)-3) More on reddit.com
9
4
May 23, 2022Is there a way to remove the last two characters from a field?
u/jennrh - Your post was submitted successfully. Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread. Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. Include your Excel version and all other relevant information Failing to follow these steps may result in your post being removed without warning. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns. More on reddit.com
23
18
February 15, 2024Formula to extract the last 5 digits of a text string into a different column?
Assuming the string is in cell A2, use this formula: =right(A2,5) More on reddit.com
9
4
April 3, 2020Reddit
reddit.com › r/excel › is there a way to remove the last two characters from a field?
r/excel on Reddit: Is there a way to remove the last two characters from a field?
February 15, 2024 -
Hi, I need to find the elapsed time between the start and the end of kids taking a test. The program showed start and end times, but it puts CT (central time) at the end, which means i can't just use a formula to calculate the difference. (For example, 02/14/24 08:02:15 AM CT) for both fields.
Is there a way to TRUNC or something with text? It works if I remove CT manually, but it's a big project so I don't really want to do that 1200 times.
Top answer 1 of 12
35
Use the below to convert it to a true value: =VALUE(LEFT(A1,LEN(A1)-2)) (Every date is represented as an integer in Excel, with 1 being one day. Every time is a fraction thereof. You might see this come back as a number like 43123 or something ... and that's good. It means we have a value again. Then you can format this (i.e. display it) however you want, and do calculations with it.)
2 of 12
30
If this is a 1 time thing, don't bother with a formula just use find and replace. Replace the " CT" with blank then you can do your formula. Another option you could use the text the columns function to separate your cell into 3 cells; date, time and the CT Edit, 4 columns missed Am Pm
ExcelDemy
exceldemy.com › home › excel basics › how to remove last digit in excel (6 quick methods)
How to Remove Last Digit in Excel (6 Quick Methods) - ExcelDemy
June 14, 2024 - ... Function RemoveLastDigit(input1 As String, num_digit As Long) RemoveLastDigit = Left(input1, Len(input1) - num_digit) End Function · Save the code and go to the Excel worksheet.
YouTube
youtube.com › watch
How to Remove Last 2 digits in Excel Column - YouTube
How to get rid of the last two digits or letters in a column in Microsoft ExcelTimestamps0:00 LEFT function0:16 Combine LEFT with LEN function0:29 Removing l...
Published January 10, 2023
YouTube
youtube.com › watch
How to Remove the last 2 digits from Excel - YouTube
If you are looking for a video about How to Remove the last 2 digits from Excel, here it is! That's easy and simple to do!
Published October 10, 2023
Excel Wizard
excelweez.com › home › how to remove last digit in excel: 5 simple ways
How to Remove Last Digit in Excel: 5 Simple Ways - Excel Wizard
May 26, 2023 - You can remove the last two digits in Excel using Flash fill, Left and Len, Replace and Len, or VBA code. But in this example, we will use the Left and Len functions ... 3. You can apply the same formula quickly to the remaining cells by dragging ...
Statology
statology.org › home › excel: how to remove last 2 characters from string
Excel: How to Remove Last 2 Characters from String
August 16, 2023 - Often you may want to remove the last 2 characters from a string in Excel. You can use the LEFT function combined with the LEN function to do so: ... This particular formula removes the last 2 characters from the string in cell A2.
Support Your Tech
supportyourtech.com › home › excel › how to remove last two characters in excel: a step-by-step guide
How to Remove Last Two Characters in Excel: A Step-by-Step Guide
July 26, 2024 - Open your Excel file. Select the cell to modify. Enter the formula =LEFT(A1, LEN(A1)-2). Copy the formula to other cells. Replace original data with ‘Paste Values’. Removing the last two characters in Excel is a simple yet powerful technique ...
Excel Forum
excelforum.com › excel-formulas-and-functions › 1120662-delete-last-two-digits.html
delete last two digits [SOLVED]
August 1, 2016 - I have this CV088B40 CV088B41 CV088B42 CV088B43 I want this CV088B CV088B CV088B CV088B Formula on b1 and down , data on a1 and down ... Or Data - Text to columns - Fixed with - Enter separator before the last two digits - Next - Select "do not import" for the second column - Finish
Spreadsheet Planet
spreadsheetplanet.com › home › how to remove the last digit in excel?
How to Remove the Last Digit in Excel? 4 Easy Ways!
December 6, 2022 - If you have a text dataset, you won’t be able to use it (as you can’t divide a text string by 10) ... Another way to remove the last digit in Excel is by using the REPLACE function in conjunction with the LEN function.
The Bricks
thebricks.com › home › resources › how to remove the last digit in excel
How to Remove the Last Digit in Excel - Bricks
April 22, 2025 - As you can see, Excel provides multiple ways to remove the final digit from your data. For a quick, static fix, Ctrl+E for Flash Fill is unbeatable. For flexible, dynamic results that automatically update, the formula-based approaches using LEFT/LEN or REPLACE are reliable standbys, while the TRUNC trick is a neat mathematical shortcut exclusively for numbers.
Sourcetable
sourcetable.com › how-to-excel › how-to-remove-last-2-digits-in-excel-column
Free AI Spreadsheet Assistant | Complete tasks in seconds
It provides instant help and recommendations for writing any formula, helping you work more efficiently. Try for free · Your AI Spreadsheet can analyze your data to uncover trends, patterns, and key insights. Ask questions about your data in plain English and get instant analysis and suggestions for further exploration. Try for free · Cleaning and transforming data is a breeze with your AI Assistant. Describe what you need - removing duplicates, standardizing formats, splitting columns, etc.
Published October 30, 2024
Solve Your Tech
solveyourtech.com › home › programs › how to remove last digit in excel 2013
How to Remove Last Digit in Excel 2013 - Solve Your Tech
August 11, 2023 - Select the cell to display the number with the removed digit. Type the =LEFT(A1, LEN(A1)-1) formula but replace A1 with the correct cell number. Press the Enter key to execute the formula.
YouTube
youtube.com › watch
How to remove the last digit in Excel
Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.
MrExcel
mrexcel.com › forums › question forums › excel questions
formula remove last 2 digits | MrExcel Message Board
November 3, 2003 - Is there a formula that will remove the last 2 digits from a field string which are not the same. For example Old New 12345678 123456 1234 12 12345 123 Regards ... For whole numbers... =--LEFT(A1,LEN(A1)-2) ... You must log in or register to ...
ExcelTips (ribbon)
excelribbon.tips.net › T013796_Removing_the_Last_Digit_in_a_Number.html
Removing the Last Digit in a Number (Microsoft Excel)
Obviously, the formulas described above require the use of a helper column. They also aren't terribly discriminating; they will remove the last digit from any value in cell A1 and they won't "adjust" if A1 contains text or is empty.
Reddit
reddit.com › r/excel › remove last 3 digits
r/excel on Reddit: Remove last 3 digits
May 23, 2022 -
How do I create a formula that removes the last three digits
Ex. i want A6126009968 to be A6126009