Hi, you can do something like this: =CONCATENATE(A1," ",B1," ",C1)

Dave
--
Brevity is the soul of wit.


"BenG" wrote:

I understand how to use the concatenate function to merge several cells with
text into one cell. My question is this: after the concatenate function
merges the specified cells into one cell, how can you then put spaces between
the text strings?

For example, say the concatenate function merges the following cells:
firstname, lastname, and age. The result of the concatenate function would
then be firstnamelastnameage. What I am asking is how can I then insert
spaces between the strings that were merged together so the cell would
contain firstname lastname age?