«

»

Mar 12 2017

Excel: How To Remove Characters from Beginning and End of Cell

How to Remove the LAST x characters from a cell

Using the LEFT function we can tell Excel to take the value of one cell, remove a certain number of Characters from the Left, and return the balance

eg: =LEFT(A1,LEN(A1)-5)

That code will remove the LEFT 5 characters, and return the remainder.

Another variation that I have found useful, when a Cell is full of Capital letters, is to combine the above function with the PROPER function, and change the case in the answer.

How to Remove last 5 characters from a cell, and return the answer in Proper case

eg: =PROPER(LEFT(A1,LEN(A1)-5))

That code will remove the LEFT 5 characters, and return the remainder, after changing the case to lower case, except for the first letter

For Books with Free Delivery Worldwide: BookDepository UK and USA

Leave a Reply to this Posting, but no links please.