RIGHT(text [,num_chars]) |
Returns the last or right most characters in a text string. |
text | The text string that contains the characters you want to extract. |
num_chars | (Optional) The number of characters you want to extract. |
Remarks |
* If "text" is a text string then it must be enclosed in speech marks. * The "text" can be numbers. * The "text" can be cell reference. * If "num_chars" > the length of the "text", then "text" is returned. * If "num_chars" is left blank, then 1 is used. * If "num_chars" is not numerical, then #VALUE! is returned. * If "num_chars" < 0, then #VALUE! is returned. * Any blank spaces are counted as individual characters. * If more than one cell is referenced then a Dynamic Array Formula will be applied. * You can use the LEFT function to return the first or left most characters in a text string. * You can use the TRIM function to return a text string with all spaces removed from the beginning, middle and end. * You can use the RIGHTB function if you have languages that use the double-byte character set. * For the Microsoft documentation refer to support.office.com |
|
© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top