How to intercept some characters in excel

Method: First select the specified cell, click "Formula" - "Insert Function" at the top of the page, and look for the "mid" function; then enter the text string in the new window "text" that pops up, "start_num" Enter the starting position, enter the interception length in "num_chars"; finally click the "OK" button.

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

First, open the excel table and select the cell to be edited;

Click the formula on the menu bar - "Insert Function";

The function dialog box pops up, enter "MID" in the input box, and click to find the function;

Next set the function parameters, text Enter the text string to be edited;

startnum represents the starting position. We need to get the 4th to 6th characters, so enter 4;

num_chars represents the number of intercepted strings. There are 3 characters in the 4th to 6th digits. We enter 3 and click OK, and we get the characters in the 4th to 6th digits.

Related learning recommendations: excel tutorial

The above is the detailed content of How to intercept some characters in excel. For more information, please follow other related articles on the PHP Chinese website!