Conquering Concatenation in Excel

What is Concatenation?

[{"selector":"#anim-1e0304c6-9021-4c86-bac8-96fece2dc3e3","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-1012a246-e192-460e-9ad7-ede7d234b33f","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}]

CONCATENATE Function

[{"selector":"#anim-a54578dd-926c-49d0-afcd-72f3f6ff2b9c","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-3dc4d53d-d72d-4c64-8203-86794757a888","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-3d77c50f-0014-452f-9db4-b867f711c400","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-75a7c90c-d796-488b-a695-e0dff6f1ef54","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}]

The Contender: & Operator

[{"selector":"#anim-ab21024f-5e21-4bc5-8cf9-d31774401d30","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-e4226aed-bba4-47f8-b217-074a2da606e2","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-f772b0fd-b315-4c66-82e8-f4024839cb4b","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-c52be15b-9250-461d-a7c2-d24c33f89222","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}]

TEXTJOIN Function

[{"selector":"#anim-efe52933-b52f-4ce0-b5f7-324a8093946e","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-3e922ba6-c14c-4b9e-8e2d-731f2d813fc7","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}]

Flash Fill for Speedy Concatenation

[{"selector":"#anim-a0d58850-4fe2-4d93-b67d-030aac2291b8","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-43ce67d3-1372-4fcd-926e-809413697159","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}]

Concatenation Champion!

[{"selector":"#anim-efae3041-c108-454a-a190-314ef1718758","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-e54e71bc-f352-4e4c-b66c-f9d9672b6e4f","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}]

Conquering Concatenation in Excel

What is Concatenation?

Concatenation simply means joining bits of text together to create a new string.

CONCATENATE Function

The CONCATENATE function is your go-to for merging text. Just enter the text strings and cell references.

Read more

The Contender: & Operator

The ampersand (&) is a simpler option for joining text strings.

Read more

TEXTJOIN Function

TEXTJOIN offers lets you specify a delimiter (like a comma or space) to separate the joined text strings.

Flash Fill for Speedy Concatenation

Excel's Flash Fill can automate repetitive concatenation tasks.

Concatenation Champion!

You've conquered concatenation! Now you can effortlessly combine text in your Excel spreadsheets.