You can use the formula =LEFT(text, num_chars)(text represents the data we want to extract, num_chars represents how much content we want to extract)
or =MID(text, start_num, num_chars)(text is extracted characters, start_num is extracted from the left (expressed in numbers), and num_chars is extracted from the left to the right. ( Use numerical expression)) to extract the specified part of the field.
Example:
You need to extract the first 3 digits of the following phone number, enter the formula =LEFT(C3,3) in D3, as shown below:
Click on the lower right corner of cell D3 and pull down to extract the first three digits in the table below, as shown below:
Excel Basic Tutorialcolumn!
The above is the detailed content of How to select some fields in excel. For more information, please follow other related articles on the PHP Chinese website!