ICICI

Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

Akhil Sharma (Service) (141 Points)
Replied 13 June 2012

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.

1 Like

praveen (Chartered Accountant) (6878 Points)
Replied 13 June 2012

Yes Sir.

But many do not know "& function" also.

 

Regards

Babita Jain (Personal Assistant) (153 Points)
Replied 13 May 2021

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  


Related Threads


Loading



Subscribe to the latest topics :
Search Forum:

Trending Tags