Sixth move: to the end of the first left (Right function)
This move and the move the opposite way of the interception of the last character from the beginning, back to front interception of the contents of a user-specified length.
Syntax
RIGHT (text, num_chars)
RIGHTB (text, num_bytes)
Text is included to extract the text string of characters, you can directly enter the cell containing the target name of the text.
Num_chars specify that you want RIGHT number of characters extracted.
Note: Num_chars must be greater than or equal to 0.
If num_chars greater than the length of the text, then RIGHT to return all the text.
If you ignore the num_chars, is assumed to be 1.
Application examples:
Explained
The formula "= Right (A2, 8)", said to be intercepted in the A2 data contents of the cell A2 "... Dongguan, Guangdong Province Tel: 22222222, ""8 " that started from the last of the interception of 8 characters, Therefore, the system returns "22222222. " Despite the length of the raw data missing, but we only care about the last eight phone numbers.
没有评论:
发表评论