:"Wonderful use of MID function: quickly extract the year, month and day from the ID card"-Table skills免费ppt模版下载-道格办公

"Wonderful use of MID function: quickly extract the year, month and day from the ID card"

```html

Graphic skills
Cases

The MID function is used to return a specific number of characters in a text string starting at a specified position, specified by the user.

Syntax MID(text, start_num, num_chars)

Text is the text string containing the characters to be extracted. Start_num is the position of the first character in the text to be extracted. The start_num of the first character in the text is 1. Num_chars specifies the number of characters you want the MID to return from the text.

Description

If start_num is greater than the text length, MID returns empty text.
If start_num is less than the length of the text, but start_num plus num_chars exceeds the length of the text, MID only returns characters up to the end of the text.
If start_num is less than 1, MID returns the error value #VALUE!.
If num_chars is negative, MID returns the 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/MID-han-shu-miao-yong-kuai-su-ti-qu-shen-fen-zheng-zhong-de-nian-yue-ri.html