Excel Functions to remove characters from Left and Right ends

  1. Remove characters from left of a text
    =RIGHT(A2,LEN(A2)-3)
    =RIGHT(D2,5)
    Ex: If text is POS12345 result will be 12345

    Another methode will be – =REPLACE(A2,1,N,””)
    Here N will be the number of characters to remove.
  2. Remove Charcters from right of a text
    =LEFT(A2,LEN(A2)-5)
    =LEFT(A2,3)
    Ex : If text is POS12345 result will be POS

Leave a comment

Your email address will not be published. Required fields are marked *