Do you mean something like this

=A1 & A2 & A3 & A4

This will set each value in the four cells into one cell. Something like:
A1: Test1
A2: Test2
A3:
A4: Test4

The cell with the formula: Test1Test2Test4

"Wingman" wrote:


Hello,

I have the following problem:

I have 4 columns that contain a different number of cells.

How do I combine the cells of those 4 colums to one column, without
having blank cells in (due to the different number of cells per
column)

Thanks.


--
Wingman
------------------------------------------------------------------------
Wingman's Profile: http://www.excelforum.com/member.php...o&userid=33602
View this thread: http://www.excelforum.com/showthread...hreadid=540347