How to extract person's name in excel
- 藏色散人Original
- 2020-02-12 09:59:4123195browse
How to extract a person’s name in excel?
First open the table. The odd-numbered rows in the table are student numbers, and the even-numbered rows are names. To extract the names in even-numbered rows
select the cell that displays the name, in this case it is cell D1
Input the formula: =INDEX(B:B,ROW()*2)&"", press the "Enter" key
to get the even-numbered row names, and then enter Pull down the table so that all the names are extracted
For more Excel-related technical articles, please visit the Excel Basic Tutorial column!
The above is the detailed content of How to extract person's name 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 sort excel in alphabetical orderNext article：How to sort excel in alphabetical order