Concatenation is one of the common problems which occur in excel documentation. For instance below figure ‘Concatenation in action’ shows we need to concatenate the telephone number with code. While doing the concatenation we also need to separate the telephone number and area code with hyphen (“-“). This can be easily achieved by using the ‘Concatenate’ keyword. ‘Concatenate’ keyword takes series of string value and displays the same in a concatenated fashion. You can see from the figure the first is the area code, second input is the hyphen “-“and the final is the telephone number. We have also shown the actual output for the same in the same figure.