Home Computer Learn how to use excel formula concatenate.
Computer MS Office

Learn how to use excel formula concatenate.

By amitgupta
Posted on June 22, 2022
37 second read
0
0
81
1ST.1 2

 CONCATENATE

how to use concatenate on excel

What Does It Do?

This function joins separate pieces of text into one item.
 
Syntax
 =CONCATENATE(Text1,Text2,Text3…Text30)
Up to thirty pieces of text can be joined.
 
Formatting
No special formatting is needed, the result will be shown as normal text.
 
Note
You can achieve the same result by using the & operator.
 
opposite word of concatenate in excel
Load More Related Articles
Load More By amitgupta
Load More In Computer
Click To Comment

Leave a Reply

Check Also

What is Account Master & How to Create Modify and Delete

What is Account Master & How to Create Modify and Delete Administration > Masters &…