How to use Concatenate Function in Microsoft Excel in Easy Way
[Full Tutorial]
Description:
In this tutorial, we will discuss, How to use Concatenate Function in Microsoft Excel in Easy Way. Excel has an excellent assortment of worksheet functions that can handle text. You can access these functions just where you’d expect: from the Text control in the Function Library group of the Formula tab.
How to use Concatenate Function in Microsoft Excel in Easy Way
Author Writer: Arshad Sultan [ Expert ]
Author Uploaded: Arshad Sultan
Download Official Link:
[ https://products.office.com/en-us/microsoft-excel-2007 ]
Tutorial About:
1> How To Use Count Function [ EasyWay ]
2> How To Use Function [ Latest To Old Version ]
Version: 2007 To 2016
CONCATENATE FUNCTION
Concatenate Function use to Joining two or more cells.
The Excel Concatenate Function joins two or more text strings into one text string. CONCATENATE function, which takes up to 255 arguments. For example: CONCATENATE(A1,B1,C1,D1).
Syntax:
=CONCATENATE (text1, text2, [text3], …)
Use & Operator:
Example 01:
= B3[Tutorials]&C3[Ocean] return TutorialsOcean
If you want to add space between text then use double commas between string.