Excel: How To Remove Characters from Beginning and End of 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)

ai2

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


These Adverts help to pay for this site.

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))


Agoda HolidaysAgoda HolidaysThese Adverts help to pay for this site.

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


7.1 - 546,017
Scroll down for Comments
0 0 vote
Article Rating
Subscribe
Notify of

This site uses Akismet to reduce spam. Learn how your comment data is processed.

0 Comments
Inline Feedbacks
View all comments