Merging text columns

[RyanR8881]

My work sheet looks like this:

4616 l STOKES l ST
2844 l OAKDALE l ST
2919 l KING COLE l DR
3504 l COLONIAL l AVE
3218 l SUNNYVALE l ST
2837 l OAKDALE l ST
3714 l SUNNYVALE l ST

I want to merge to be like this "4616 STOKES ST". Whats the easiest way to
do this?

 

[John C]

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

Hope this helps.