or
you must type this all in one cell ie select the cell and press F2 then paste else it will fill a few cells down and not work, or double click to entre the cell top paste
=A1&
" "&
B1&
" "&
C1&
" "&
D1
now this i make formula this ways as i teach guys so they can edit them and understand the construction. also this way you and tweak and edit with ease ive added a space between cells jsut to devide them can be removed,
THIS is MY way or formula, not very pretty just like me i guess..
HTH