Home Computer Learn how to use excel formula concatenate.

Learn how to use excel formula concatenate.

37 second read
0
0
51
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

Leave a Reply

Check Also

How to Check BUSY Updates

How to Check BUSY Updates Company > Check BUSY Updates Check BUSY Updates option provid…