Thread: Trying to merge information into one cell

Can't remember how to merge information into one cell (used to be able to do it) old age setting in I think. I want to merge three cells information into one, ie; mr; andrew; jones so that I can input onto my database as mr. andrew jones anyone help please?

Hello
If for example Mr. Andrew Jones is in cells A1: B1 and C1.

=A1&" "&B1&" "&C1

or

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

Hope this helps.