Values in multiple columns into one column

[Daniel]

Hi everyone,

I have a spreadsheet with values in multiple columns
where for instance col A is blank colb or c or d won't
be...there will be something in one where the others are
empty. I need to create a column with all the values
together. Tried using the following formula but it
doesn't seem to work... the values are all dates..

=IF(O2=" ",N2,IF(N2=" ",K2,IF(K2=" ",J2,O2)))

Can anybody help!!

Cheers
Dan

 

[Frank Kabel]

Hi
try
=IF(O2="",N2,IF(N2="",K2,IF(K2="",J2,O2)))

 

[Guest]

sTILL NOT WORKING. RETURND A 0 in the columns.

-----Original Message-----
Hi
try
=IF(O2="",N2,IF(N2="",K2,IF(K2="",J2,O2)))

.

 

[Frank Kabel]

Hi
can you provide some example data for your columns (plain
text - no attachment please) and your desired result for
each row