Remove Last Character from String Excel

What this does

Both formulas work the same way: measure the text with LEN, then keep everything except the n characters you are dropping. RIGHT keeps the tail, so it removes from the front; LEFT keeps the head, so it removes from the back. MID(A2, n+1, LEN(A2)) is an equivalent way to say the first, and REPLACE(A2, 1, n, "") an equivalent way again. Microsoft 365 adds two functions that express the intent directly when there is a delimiter to work from: TEXTAFTER(A2, "-") takes everything after the first hyphen and TEXTBEFORE(A2, "-") everything before it, which is more robust than a character count when the prefix length varies. Two cautions apply generally. The result is always TEXT, so a product code stripped of its letter prefix will not behave as a number until you wrap it in VALUE. And if the prefix length is not actually constant, a fixed count silently mangles the rows where it differs — check with =LEN(A2) down the column before trusting it. Most people learn this as a sequence of clicks and forget it by next week; learning it as a pattern instead is what lets you apply it to the next, slightly different version of the problem without starting from scratch. That is the difference this page is trying to make. For “remove last character from string excel”, the reliable version is a short checking loop, not just the first command that appears to work. Run it on a deliberately small range first, watch how the affected cells change, and only then apply the same setup to the full sheet. When a formula is involved, keep the inputs labelled beside it, reference cells instead of typing values, and apply number formatting only after the result checks out. That is what makes a text operation that turns messy entries into clean, usable data useful in real work: repeatable, auditable, and not dependent on memory or luck.

A worked example

Codes like P-04821 in A2. =RIGHT(A2, LEN(A2)-2) drops the "P-" leaving 04821 as text; =VALUE(RIGHT(A2, LEN(A2)-2)) gives the number 4821, which also drops the leading zero — so keep it as text if the zero is meaningful. Where the prefix varies (P-, PR-, PROD-), =TEXTAFTER(A2, "-") is correct for all three, and a fixed count is correct for none. Stripped prefixes are what stand between an exported code column and a lookup that matches, and the only real risk is assuming a prefix length that varies. If there is any chance you will reuse this, drop it into a small template tab right now: a labelled input area on the left and the formula beside it, checked once against the tool above. Next time the same question comes up, the answer is a single paste away instead of a rebuild from memory.

In Google Sheets

Some functions on this page are newer additions to Excel: they are in current Microsoft 365 and Excel for the web, while older perpetual Excel versions return #NAME?. Google Sheets maintains its own function list, so confirm each function exists there before relying on the same formula. Keep this page bookmarked for the next time the same question comes up. Better still, rebuild the example once in your own sheet — doing it yourself, with the tool above to check against, is what turns a copied formula into a technique you own. If you take one thing from this page on “remove last character from string excel”, make it the habit rather than the keystrokes: set the problem up with labelled inputs, reference those cells, and let Excel do the recomputing. Bookmark the page for the syntax, but do the example once in a blank sheet and check it against the tool above — five minutes of hands-on practice fixes the method in memory far better than re-reading, and it surfaces the small snags while they are still harmless. After that the technique is genuinely yours: faster than searching for it again, and reliable enough to drop into work that other people depend on.

Common mistakes

• Swapping LEFT and RIGHT — RIGHT removes from the start, which reads backwards until you think about which end it keeps.
• Assuming a fixed prefix length and corrupting the rows where it differs.
• Leaving the result as text and then failing to sum or look it up.
• Deleting the source column before pasting the results as values, which fills the column with #REF!.
• Using a character count where trailing spaces are the real problem — TRIM is the right tool for that.

Frequently asked questions