Use of Concatenate Command

Last updated at August 8, 2026 by

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

CONCATENATE.xlsx

 

Example 2

 

Example 3

Example 4

Remove Ads
CA Maninder Singh's photo - Co-founder, Teachoo

Made by

CA Maninder Singh

CA Maninder Singh is a Chartered Accountant with 16+ years of practical experience and 20+ years of teaching experience. At Teachoo, he simplifies Accounts, Tax and GST with step-by-step examples so students can apply concepts confidently in exams and real life.

For an uninterrupted learning experience, students can use Teachoo Black to remove ads and focus better.