Unused but very useful formula : concatenate

Check out on how to use the formula concatenate with example

 

Replies (3)

In case we want to combine the values in multiple cells in excel, we use "CONCATENATE" function.  For example, we want to combine the values of cell A1 and B1 the formula will be =Concatenate(A1,B1). 

Why this function has been mostly unused because we can get the same result by using "&".  For example, in the above case we can get the same result by =A1&B1.

Yes Sir.

But many do not know "& function" also.

 

Regards

You can combine text data from two or more cells / columns into a single cell / column using the Ampersand symbol (&) or the CONCAT / CONCATENATE formula function.

An example formula might be =CONCAT(A2,B2," Family"). 

See Step Step Guide Video - Excel formula tutorial | All Excel tutorial

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 28 October 2026
Article assistants

Shyam S Gupta and Company

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 25 October 2026
Article Intern (CA Articleship)

Arpan Bohra & Co

Hyderabad

CA Inter

View Details
Company
ARTICLESHIP 07 November 2026
Article Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
ARTICLESHIP 23 October 2026
CA Articleship / Article Assistant

M N Rao & Associates LLP

Vijayawada

CA Inter

View Details
Company
14 November 2026
Manager - Indirect Tax (GST)

Westbridge Consulting LLP

New Delhi

CA

View Details
Company
20 November 2026
Senior Accountant

Compass Tex India Pvt Ltd

Coimbatore

CA Inter

View Details
Company
ARTICLESHIP 20 November 2026
Article clerk

Jain Sanjay Kumar & Co

Jaipur

CA Inter

View Details
Company
ARTICLESHIP 14 November 2026
Articleship Assistant

B Thejas and Associates

Bengaluru

CA Foundation

View Details