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:
##Use the formula =MID(C5,13, 3): For more Excel-related technical articles, please visit theExcel Basic Tutorial column!
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!