In the above example, we have name of a person in A1 and in the cell C1 we have extracted the last name using =RIGHT(A1,5) formula. The formula extracts the last 5 characters from right in the cell A1.
March 16, 2010
Extract characters from right of a text
If you would like to split some number of characters in a text from right. We can do that, please look into the below example,
In the above example, we have name of a person in A1 and in the cell C1 we have extracted the last name using =RIGHT(A1,5) formula. The formula extracts the last 5 characters from right in the cell A1.
In the above example, we have name of a person in A1 and in the cell C1 we have extracted the last name using =RIGHT(A1,5) formula. The formula extracts the last 5 characters from right in the cell A1.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment