<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=539359806247306&ev=PageView&noscript=1"/>

It is used to

combine or merge date in 2 or more cells

or add a value between 2 or more cells

 

Formula of Concatenate

=Concatenate(First Value,Second Value)

If value is text,we need to put inverted commas "  "

 

Example 1

Use of Concatenate Command - Concatenate

 

Download Excel File And Try

 

Example 2

 

Example 3

Example 4

About the Author

CA Maninder Singh's photo - Expert in Practical Accounts, Taxation and Efiling
CA Maninder Singh
CA Maninder Singh is a Chartered Accountant for the past 6 years. He provides courses for Practical Accounts, Taxation and Efiling at teachoo.com.
Didn't understand? Ask your question or doubt free.

Apna sawal puchiye!

Jail