Home  >  Article  >  Topics  >  How to use mid function

How to use mid function

coldplay.xixi
coldplay.xixiOriginal
2021-02-03 15:09:58124981browse

How to use the mid function: First open Excel and enter characters in cell A1; then enter the function "=MID (A1, 4, 3)" in cell A2; the final result should be "Browse device".

How to use mid function

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2007 version, Dell G3 computer.

How to use the mid function:

1. The following is an example. Here is Excel2007 as an example. Open Excel and enter characters in cell A1. Here Enter "360 Browser".

How to use mid function

2. Then enter the function "=MID (A1, 4, 3)" in cell A2, which means to start extracting from the 4th character in cell A1 , the extracted characters are 3, so the final result should be "browser". Note: Numbers including punctuation marks are also characters.

How to use mid function

#3. After entering the formula, press the enter key, and the result will appear, as shown in the figure below.

How to use mid function

Related learning recommendations: excel tutorial

The above is the detailed content of How to use mid function. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn