反馈已提交
网络繁忙
Grammar
MID(text,start_num,num_chars)
Returns a user-specified number of characters from a specified position of a string.
Parameter 1
Text
Text string containing characters to be extracted
Parameter 2
Start_num
Starting position to extract characters. To extract from the first character in the text, set start_num to 1. The rules for extracting from other positions of characters are deductive.
Parameter 3
Num_chars
Number of characters to be extracted
The MID function supports 3 parameters, among which the first parameter is of any type, and the second and third are numeric.
If start_num is greater than the length of text, MID returns "" (empty text).
If start_num is less than the length of text, but it plus num_chars exceeds the text length, MID returns the characters from the starting position to the end of text.
If start_num is less than 1, MID returns the error value *VALUE!.
If num_chars is less than 0, MID also returns the error value *VALUE!.
フィードバック
鼠标选中内容,快速反馈问题
鼠标选中存在疑惑的内容,即可快速反馈问题,我们将会跟进处理。
不再提示
10s后关闭