Combine Cells

J

Johnny B

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
 
Top