- Picture and text skills
- Case
MID returns a user-specified number of characters in a text string starting at the specified position.
strong>
Syntax
MID(text,start_num,num_chars)
Text is the text string containing the characters to be extracted.
Start_num is the first element to be extracted from the text character position. The first character in the text has start_num equal to 1, and so on.
Num_chars specifies the characters you want MID to return from the text number.
Description
■ If start_num is greater than the text length, MID returns empty text().
■ If start_num is less than the text length, but start_num If num_chars exceeds the length of the text, MID will only return up to the text
The character at the end of this.
■ If start_num is less than 1, MID returns the error value #VALUE!.
■ If num_chars is a negative number, MID returns Error value #VALUE!.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/biao-ge-wen-ben-han-shu-qiao-yong-MID-han-shu-yi-miao-ti-qu-shen-fen-zheng-nian-yue-ri.html
评论列表(196条)
测试