Check sibling questions

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

Davneet Singh's photo - Teacher, Engineer, Marketer

Made by

Davneet Singh

Davneet Singh is a graduate from Indian Institute of Technology, Kanpur. He has been teaching from the past 12 years. He provides courses for Maths and Science at Teachoo.