hey guys sorry i tried using
=A1&" "&B1
and
=CONCATENATE(A1," ",B1)

both worked, but my question is:
how do i work with the actually value in the cell rather than the function.
For example:

instead of
=CONCATENATE(A1," ",B1)
in the cell, How can i work with:
John Smith [which is the result of =CONCATENATE(A1," ",B1)]

Thanks,
Johnny B

"Johnny B" wrote:

Hey everyone, i had a quick question. How do you combine separate adjacent,
horizontal cells into one cell? For example:

Column A|B |C | D |E|
|John | Smith | is| going | to the store|

into

|John Smith is going to the store|

i tried using the merge option, but all i get is what is in the first cell,
like:

|John|

Thanks for your time!,

Johnny B