How to Remove Last 3 Characters in Excel

How to Remove Last Three Characters in Microsoft Excel

In this intermediate Excel tutorial, I’ll explain how to delete the last nth character from an Excel cell. This means using this formula, you’ll be able to remove the last 3, last 5, last 10, etc., characters from a cell or text or even number in Excel.
Here, I’ll be using a formula to solve this, and in my formula, I’ve used two Excel functions: Left and Len. Check the videos below to learn about these functions:

How to use Left Function in Excel:    • How to use LEFT Function In Excel  
How to use Len function in Excel:    • How to Use LEN Function in Excel  

Now that you know the functions, let's assess the scenario and use the formula.

In cell A1, I have the number 123456789. In cell B1, I want to keep 123456, removing the last three characters.
I’ll be writing the formula in cell B1, and the formula will be:
=LEFT(A1,LEN(A1)-3)

Let's break it down:
LEFT: This is a function that extracts a specified number of characters from the LEFT side of a text string.
A1: This refers to the cell from which you want to extract the text.
LEN(A1): This function returns the length of the text in cell A1.
LEN(A1)-3: This calculates the length of the text in cell A1 and subtracts 3 from it. This effectively removes the last three characters from the text.

So, putting it all together, =LEFT(A1,LEN(A1)-3) takes the text from cell A1 and extracts all characters starting from the first character except the last 3 characters of the text. Essentially, it removes the last three characters from the text in cell A1.

#Remove #Character #ExcelFormula

Thanks for watching.
----------------------------------------------------------------------------------------
Support the channel with as low as $5
www.patreon.com/excel10tutorial
----------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
goo.gl/uL8fqQ

Here goes the most recent video of the channel:
bit.ly/2UngIwS

Playlists:

Excel Tutorial for Beginners: goo.gl/UDrDcA
Intermediate Excel Tutorial: tinyurl.com/59a837py
Advance Excel Tutorial: goo.gl/ExYy7v
Excel Text Case Conversion Techniques: goo.gl/xiP3tv
Combine Workbook & Worksheets: bit.ly/2Tpf7DB
All About Comments in Excel: bit.ly/excelcomments
Excel VBA Programming Course: bit.ly/excelvbacourse
ChatGPT Excel Mastermind: tinyurl.com/46kn7tmd

Social media:
Facebook: facebook.com/excel10tutorial
Twitter: twitter.com/excel10tutorial
Blogger: excel10tutorial.blogspot.com/
Tumblr: excel10tutorial.tumblr.com/
Instagram: www.instagram.com/excel_10_tutorial
Hubpages: hubpages.com/@excel10tutorial
Quora: bit.ly/3bxB8JG
Website: msexceltutorial.com/ Become a member and enjoy exclusive perks while supporting the channel you love!
youtube.com/channel/UCvYWtCPVbIDYLyNqB4lRIaw/join