LEFT and RIGHT function allow you to remove the certain characters from the beginning or end of one or several. The example below removes the first 4 character from the beginning of A1 cell.
B1: =RIGHT(A1, LEN(A1)-4)
This removes 4 character from the end of the text in A1 cell.
C1: =LEFT(A1, LEN(A1)-4)
No comments:
Post a Comment