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.
Example 02:
= B3[Tutorials]&” “&C3[Ocean] return Tutorials Ocean
Use Concatenate Function:
Example 01:
= CONCATENATE(B3,C3)
Example 02:
= CONCATENATE(A1, ” “,B1)
Example 03:
Contact:
Any Kind Of Help Or Needs So Contact Me:
Facebook Group: [ https://www.facebook.com/Tutorials-Ocean-185506455425271/ ]
TAGS:
ms excel, microsoft excel, formulas, functions, concatenate function, worksheet function, syntax, parameters, arguments, example, tutorial, join text function, & operator in Excel, excel function library, concatenate syntax
About Post Author
