consolidate text from 4 cells into 1

[Larry]

I have text in cells A1, A2, A3, and A4 that I want to consolidate into 1
cell "A5".

Anyone know how?

 

[Frank Kabel]

Hi
try
=A1 & A2 & A3 & A4

or if you want spaced in between try
=A1 & " " & A2 & " " & A3 & " " & A4

 

[Larry]

Thanks that was easy!

Hi
try
=A1 & A2 & A3 & A4

or if you want spaced in between try
=A1 & " " & A2 & " " & A3 & " " & A4

 

[Alice]

Try using the concatenate function.

-----Original Message-----
Hi
try
=A1 & A2 & A3 & A4

or if you want spaced in between try
=A1 & " " & A2 & " " & A3 & " " & A4

--
Regards
Frank Kabel
Frankfurt, Germany

consolidate
into 1

.