The Excel RIGHT function extracts a given number of characters from the right side of a supplied text string.
🆂🆈🅽🆃🅰🆇
RIGHT (text, [num_chars])
🅰🆁🅶🆄🅼🅴🅽🆃🆂
text - The text from which to extract characters on the right.
num_chars - [optional] The number of characters to extract, starting on the right. Optional, default = 1.
It can also be applied on numbers.
In the example the 2nd argument not mentioned, so extracting only single character from right.
When supplied with any number more than the number of characters in the given text string, it will return the whole text string.
Often RIGHT function used with Left Function to extract first, middle and last name from a name field.
If you have any questions, write to me at dataentryikc@gmail.com
0 comments:
Post a Comment
If you have any queries, please let me know.