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

Get live Maths 1-on-1 Classs - Class 6 to 12

Ask a doubt
CA Maninder Singh's photo - Co-founder, Teachoo

Made by

CA Maninder Singh

CA Maninder Singh is a Chartered Accountant for the past 13 years. He also provides Accounts Tax GST Training in Delhi, Kerala and online.