consolidate text from 4 cells into 1

L

Larry

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

Anyone know how?
 
F

Frank Kabel

Hi
try
=A1 & A2 & A3 & A4

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

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

.
Click to expand...
 
Top