How to use formulas to extract the names of provinces and cities in EXCEL tables

1. First, the "find" function is mainly used to determine the specific location of some character data in the data string in the cell.

2. Open the worksheet, click and select the H2 cell, enter the formula "=LEFT(G2, FIND ("province", G2)), and press Enter on the keyboard to calculate the result.

3. You can see that the province has been extracted in H2 cells.

4. Then click the mouse to select the cell, and fill the formula in the following cell to complete the extraction of provinces.

5. The syntax of the find function is find (find _ test, within _ text, [start _ num]).

6.find_test: the searched text character, within_text: the text string containing the searched text, and start_num: the specified search character.