Combining Cells-how do I combine the results of 3 columns

[eyeball11]

Probably an extremely stupid question but how do I combine the results of 3 columns? For example in A1 I have 2071000, in B1 I have / and in C1 I have A.

End result should be 2071000 / A.

[Ron Coderre]

Try this:

Please Login or Register  to view this content.

Does that help?

[zbor]

Try =CONCATENATE(A1, B1, C1)

but if you want them separate you'll need:

=CONCATENATE(A1, " ", B1, " ", C1)

[eyeball11]

Try this:

Please Login or Register  to view this content.

Does that help?

For the love of God!! I had the same thing but had VALUE outside brackets of your formula.

Thanks and sorry for being an idiot!!