Learn how to use the Concatenate formula in MS Excel in Hindi. The Concatenate formula in Excel can be used to join data in different cells into a single cell.
The Excel Guru has displayed 2 ways of using the Concatenate Formula in Excel
1) By entering the formula syntax = concatenate(text1, text2)
here the Guru has also instructed about adding a space a comma or a specific value in the final result.
2) By using the Fx insert formula feature of MS Excel.
Do provide your comment on…