Home  >  Article  >  Topics  >  How to extract part of the text in a cell in excel

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

coldplay.xixi
coldplay.xixiOriginal
2020-10-19 10:44:39120280browse

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

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.

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

#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.

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

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

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

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

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

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

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

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!

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