:Tabular text function CONCATENATE function-Table skills免费ppt模版下载-道格办公

Tabular text function CONCATENATE function

Picture and text skills
Case

Combine several text strings into one text string.

Syntax
CONCATENATE (text1,text2,...)
Text1, text2, ... are 1 to 30 text items that will be combined into a single text item.

These text items can be text strings, numbers, or references to individual cells.

Description
You can also use the & (amp;) operator instead of the function CONCATENATE to merge text items.

When we want to When the contents of multiple cells are combined into one cell, you can use the CONCATENATE function.
Its function is to merge several text strings into one text string, which can achieve 1 to 30 contents that will be merged into a single text item .
Let's practice it in the table to help everyone understand this function.

￭ Select cell (B2), click Insert function, find CONCATENATE, and click OK.

￭ In "String", select and fill in (A3), (A2), (A4) according to the order of the characters we want to synthesize. ,
Click OK, and you will see that the string has been successfully synthesized into "Thanos snapped his fingers."

Using this function, we can merge characters very quickly!

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/biao-ge-wen-ben-han-shu-CONCATENATE-han-shu.html