Merge 3 cells in one
 

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 Im having prob with
email and company names company names are in 3 cells like long/&/Foster/
dont 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

Merge 3 cells in one
 

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.
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Gary" wrote:

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 Im having prob with
email and company names company names are in 3 cells like long/&/Foster/
dont 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