Home  >  Article  >  Topics  >  How to select some fields in excel

How to select some fields in excel

尚
Original
2019-06-12 15:25:4128380browse

How to select some fields in excel

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:

How to select some fields in excel

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:

How to select some fields in excel

##Use the formula =MID(C5,13, 3):

How to select some fields in excel

For more Excel-related technical articles, please visit the

Excel 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!

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
Previous article:How to total in excelNext article:How to total in excel