How to extract part of the text in a cell in excel

How to extract part of the text in a cell in excel: first open the excel table; then enter the formula in the table and use the mid function [=mid(A1,3,2)]; finally, drop down the list to get all.

How to extract part of the text in a cell in excel:

1. First, open the EXCEL table on the computer desktop , there is the following data in column A of Excel, from which the city name is extracted, for example, "Qingdao" is extracted from column A to column B.

#2. Because these data patterns are very fixed, they can be extracted by column splitting, quick filling, etc. The mid function is used here, and the display starts from the third character. To start, extract 2 characters.

#3. After entering the mid function, you can see that the function has three parameters.

4. Press Enter to end the input of the formula.

#5. Drop down the fill formula to get the final result and complete the extraction of part of the text in the cell.

Related learning recommendations: excel basic tutorial

The above is the detailed content of How to extract part of the text in a cell in excel. For more information, please follow other related articles on the PHP Chinese website!