Combining Cells- Concatenate

In order to combine 2 or more cells we can use a function  called "CONCATENATE" .It is one of the most useful function in Excel .

Syntax: Concatenate(text1,text 2,...)

Example:




Note :For giving space between words, we should give a space in between two double quotes


No comments:

Post a Comment