Home  >  Article  >  Topics  >  How to use & in excel function

How to use & in excel function

藏色散人
藏色散人Original
2020-03-06 08:52:588802browse

How to use & in excel function

&How to use it in excel function?

On the laptop desktop, create a new Excel worksheet, Naming special symbols. Month and combination)

In cell C2 of the combination column, enter =A2&B2 for string splicing

How to use & in excel function

settings After completion, use the mouse to drag from top to bottom to combine the columns to generate

How to use & in excel function

. In cell D2, add the function formula VLOOKUP and use &

How to use & in excel function

Save the document settings and view the displayed effect

How to use & in excel function

The above is the detailed content of How to use & in excel function. 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