Concatenate Formula in Excel Hindi

TeachToEach video on how to use concatenate formula in excel Hindi. This trick explains excel advance concatenate function with syntax in excel in hindi.

With the help of this video you learn -:

1) Concatenate formula in 2016, 2013, 2010 and 2007

2) Concatenate formula with UPPER, Lower and PROPER case Formula.

3) Advance concatenate formula with IF and ISTEXT formula.

Concatenate formula used to combine two or more than two cell value in excel worksheet. We can also use thisformula with some other formula to make it advanced.

SYNTAX of Formula

=CONCATENATE(Text1,Text2-----------n)

Parameters

Text means a cell which you want to combine.


It is a very difficult task to anyone. If you are really interested to learn this trick then this video never lets you down.

On youtube, only just few videos are available on this topic of how to combine two cells in excel with a space in between

Thanks for watching. It is humble request to you please subscribe
my Channel    / teachtoeach  

Some popular videos-:

1) How to calculate Shrinkage and Attrition rate Formula in Excel Hindi -    • How to calculate Shrinkage and Attrit...  

2) Double Vlookup in Excel Hindi -    • Double Vlookup in Excel Hindi  

3) Split first middle and last name by using formula in excel hindi -    • Split first middle and last name by u...  

4) Create Dependent Drop Down List in Excel Hindi -    • Create Dependent Drop Down List in Ex...  

5) How to make a picture lookup in excel -    • How to create a picture lookup in exc...  

6) Relative Absolute and Mixed Cell Referencing in Excel -    • Relative Absolute and Mixed Cell Refe...  

7) Excel Logical Functions IF AND OR NESTED IF in Hindi -    • Excel Logical Functions  IF AND OR NE...  

8) Reverse Lookup Formula Vlookup with Choose Function in Excel -    • Reverse Lookup Formula Vlookup with C...  

9) 2D-Two Dimensional Lookup Formula Vlookup with Match in Excel -    • 2D-Two Dimensional Lookup Formula Vlo...  

10) How to consolidate multiple worksheets into Pivot Table -    • How to consolidate multiple worksheet...