Excel Formulas: How to Remove Characters from the Beginning or End of Data in a Cell / Tutorial

4 years ago
2

Remove characters that are on the left side (example)
=RIGHT(E3,LEN(E3)-3)
• Keeps the right section, reduces the length by 3 characters, removes the left 3 characters

Remove characters that are on the right side
=LEFT(E3,LEN(E3)-3)
• Keeps the left section, reduces the length by 3 characters, removes the right 3 characters

Loading comments...