Home > Topics > excel > body text

How to replace different content in excel at one time

醉折花枝作酒筹
Release: 2021-04-30 14:20:41
Original
31522 people have browsed it

Method: First select the specified cell, click "Insert Function" at the top of the page; then enter "vlookup" in the pop-up window; then enter the value to be searched in "Find Value", "Data Table" Enter the range of the information table; finally enter the specified number in "Column sequence value", enter "false" in "Matching condition", and click "OK".

How to replace different content in excel at one time

The operating environment of this tutorial: windows7 system, WPS Office 2019 version, Dell G3 computer.

We open the excel table. For example, if we want to replace the letters in column A with the corresponding names, enter the information table in the blank area, with one column for letters and one column for names;

How to replace different content in excel at one time

Place the mouse behind the cell to be replaced, click "Formula" - Insert function;

How to replace different content in excel at one time

In the pop-up function window, we select, You can quickly find it by entering V in the input box and click OK;

How to replace different content in excel at one time

Next set the function parameters, enter the value to be searched in the first column of lookup value, and In the second line of parameters, select the range of the information table. Note that you must add $absolute reference after selection. Enter 2 in the third line of col_index_num, and enter FALSE in the fourth line of parameters. Click OK to get the name corresponding to the letter A;

How to replace different content in excel at one time

Finally, place the mouse on the lower right corner of the cell and drag it down to automatically replace the data in column A with column B.

How to replace different content in excel at one time

Related learning recommendations: excel tutorial

The above is the detailed content of How to replace different content in excel at one time. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!