CONCATENATE Function in Excel
CONCATENATE function is used for combining two or more Microsoft Excel strings into one. The output of the function returns as a combined string in a new cell.
Function should give output in “General” format, however if output is not as per the desired format then we need to change the cell format to “GENERAL”.
CONCATENATE Function has argument called “text”, where we need to give the cell references, we can give multiple cell references as per the requirement to combine by following the “ , “ (i.e. Comma) as separator.
Formula =CONCATENATE(
How to Use Concatenate Function in Excel?
The CONCATENATE function allows you to combine text from different cells into one cell. In our example, we can use it to combine the text in column A and column B to create a combined name in a new column. Before we start writing the function, we’ll need to insert a new column in our spreadsheet for this data. Lets learn with few examples given below:-
Example 1:- Concatenating the Values of Several Cells
As we can see in the below images by applying simple CONCATENATING Formula two cell values are easily combined into one.
Formula =CONCATENATE(A2,” “,B2)
Formula applied
Results
Example 2 :- Concatenating a Text String and a Cell Value
The Excel CONCATENATE function is not only combined cell values. we can use the function to join a cell value and a string as well. For example:-
Important Points
- There should be at least one “text” argument in the CONCATENATE function.
- If the CONCATENATE function’s arguments are invalid, the formula returns a #VALUE! Error.
- The result of the CONCATENATE function is always a text string, even when all the source values are numbers.
Recommended Articles
Secrets of Excel Data Visualization: Beginners to Advanced Course
Here is another best rated Excel Charts and Graph Course from ExcelSirJi. This courses also includes On Demand Videos, Practice Assignments, Q&A Support from our Experts.
This Course will enable you to become Excel Data Visualization Expert as it consists many charts preparation method which you will not find over the internet.
So Enroll now to become expert in Excel Data Visualization. Click here to Enroll.
Excel VBA Course : Beginners to Advanced
We are offering Excel VBA Course for Beginners to Experts at discounted prices. The courses includes On Demand Videos, Practice Assignments, Q&A Support from our Experts. Also after successfully completion of the certification, will share the success with Certificate of Completion
This course is going to help you to excel your skills in Excel VBA with our real time case studies.
Lets get connected and start learning now. Click here to Enroll.
Use Automated Excel Utility Tools to increase productivity
- Quickly Move or Delete Files or Folder >> Click here
- Handle Duplicate Files with Automated Utlity >> Click here
- Generate Dummy Data For Testing >> Click here
- Excel Files and Sheets Consolidator >> Click here
- Manage Outlook Emails efficiently >> CLick here
- Send Bulk Emails wiht our Excel Automation >> Click here
Hope you are enjoying learning Excel with us, if you want any support related to this article, please do comment else you can ask questions in Excel Community
