How to extract person's name in excel

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!