How can I make a formula to take text from multiple cells and put it all in one cell?

[budbiss]

I am assuming there is a way i can reference each cell in one cell an
have all the text be merged together, right

 

[gls858]

I am assuming there is a way i can reference each cell in one cell and

have all the text be merged together, right?

try this =CONCATENATE(A1,B1,C1,D1)
replace with the cells of your choice

gls858

 

[Frank Kabel]

Hi
try
=A1 & B1 & C1