Concatenate

[Barry1903]

Hello I have data in 2 columns that I need to concatenate. How do I do this as I have no idea what concatenate means!!

[NBVC]

Concatenating is "chaining together" text strings....

There are 2 ways to do it in native Excel.

1. =Concatenate(A1,B1)

2. A1&B1

Both do the same thing...they take what is in B1 and add it to the end of what is in A1...

e.g. If A1 contains the word "dog" and B1 contains "cat", then the result of the formulas above in C1 would be "dogcat"

[ChemistB]

And if you wish to separate the concatenated strings with a space simply put the space between quotes as follows

= A1 & " " & B1
or
=CONCATENATE(A1," ",B1)

ChemistB