[PDF]Concatenate Function In Excel

Imparting knowledge

Gyan Sangrah

Concatenate function in excel

In this article, we will discuss concatenate function in excel.

Purpose

Literally, concatenate means - ‘link something together in a series’. So concatenate function
joins one or more strings.

Syntax

CONCATENATE(stringl, string 2, .,string n)



Example





A

A

B

C 1 D I E 1 F G H L 1

1



[This [is [the [test [string

2







3






=C0NCATENATE(D1,E1,F1,G1,H1)

4










5










6

7



















fi










9










10












A

A B 1 C D

E

F

G

H

1

1




This

is

the

test

string


2










3






Thisistheteststring



4






1



5