Merge 3 cells in one

[Gary]

Have a work sheet 1500 name addresses phone # email address and company names
all in one cell. the first and last names were easy now I’m having prob with
email and company names company names are in 3 cells like long/&/Foster/
don’t know how to combine I get getting confused with the formulas there are
1500 cells need to be combined and phone # and email address
Thanks
Gary

 

[Michael]

use the ampersand to concatenate
For example:
In f1 you could have: =A1& " " & B1 & " " & C1
If you had in A1 Long
and in B1 Foster
and c1 Something else you would get: Long Foster Something Else
in F1.