2010年12月16日星期四

Excel from the rookie to become a master of the Right function

 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.

没有评论:

发表评论