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)


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


39.1 - 806,234
Scroll down for Comments
0 0 votes
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
0
Would love your thoughts, please comment.x
()
x