What is concatenate?

How can we use concatenate in excel ?

  • Vishal
  • 22 May 2020
  • 3572 Views
  • 26 Answers
Your Answer

Concatenate is a type of text function used in excel. It is used to join multiple string in one string; string of text. The syntax for concatenate is as follows;
Syntax- concatenate(string 1, string 2, ....). let me make it more simpler by taking an example:
Given string: JAIMIN TRIVEDI; Total length of the string: 14 including space as well. Now to join both the string of text we will use concatenate function;
=concatenate("JAIMIN","TRIVEDI") ; " inverted commas are used as to join the strings. this will give the output as ; JAIMINTRIVEDI. here we can see that both the strings are joined and became as one string.
 

0
Forum   Other Related Discussions
Ms Excel

Didn't get the answer.
Contact people of Talent-Ms Excel directly by clicking here