Your Answer
-
Saket
- 06 Jul
The CONCATENATE function in Excel is designed to join different pieces of text together or combine values from several cells into one cell.
The syntax of Excel CONCATENATE is as follows:
CONCATENATE(text1, [text2], …)
Where text is a text string, cell reference or formula-driven value.
Concatenating the values of several cells
The simplest CONCATENATE formula to combine the values of cells A1 and B1 is as follows:
=CONCATENATE(A1, B1)
Please note that the values will be knit together without any delimiter,
To separate the values with a space, enter " " in the second argument,
=CONCATENATE(A1, " ", B1)
Facebook
Twitter
View all voted
Modal content
Other Related Discussions
-
Is there an alternative to Excel tables in Google Sheets?
-
Efficient alternative to repeatedly entering data manually in Excel
-
How to Get Array Length In Microsoft Excel
-
Struggling with Count ifs formula
-
Is the phone number verification only for India?
-
Job oppurtunities after doing Microsoft Excel?
-
What is Pivot table and why we use it?
-
What is Syntax of Vlookup in microsoft excel?
-
What is Microsoft Excel?define it.
-
What are the most important data formats seenin Excel and how they are used
