Method: First select "Formula" on the top toolbar and click "Insert Function"; then enter "left" in the "Find Function" input box and select "OK"; then enter the "String" text In the box, enter the name of the cell where the characters need to be extracted, and in the "Number of Characters" text box, enter the number that needs to be extracted; finally click "OK".
The operating environment of this tutorial: windows7 system, WPS Office 2019 version, Dell G3 computer.
The left function is used to extract the cell content. The syntax structure is LEFT(text, num_chars)
text represents the data we want to extract
num_chars indicates how much content to extract
The MID function is to extract a specified number of characters from a string. The syntax structure is MID(text, start_num, num_chars).
textThe extracted characters
start_numThe number from the left to start extracting (expressed in numbers)
What is the length of num_chars extracted from left to right (expressed in numbers)
Example:
Need to extract the downloaded phone number Top 3.
First open the formula option on the top toolbar, click Insert formula
Enter the required formula in the search function bar Formula, the formula we need is the left formula, just enter left in the text box and press OK.
We enter the string to extract characters in the first text box, and enter the required characters in the second text box Extract the number and click OK.
Related learning recommendations:excel tutorial
The above is the detailed content of How to extract specified fields in excel. For more information, please follow other related articles on the PHP Chinese website!