Combining values out of different columns

S

stumbler

Hi,
I've seen an answer on this one before, but I cannot find it back!

I have 2 colums i need to combine
colA ColB ColC= result
100 10 10010
20 10020
200 10 20010
30 20030
40 20040
300 20 30020
.... goes on for 1000 rows

Who can help me on this one?
Thanks in Advance
Hans
 
R

rajesh

Sorry earlier posted formula had a small mistake

corrected one

Use below formual for 1st cell

=IF(A1<>"",A1&B1,A1&B1)

Use below formual for rest of cells


=IF(A2<>"",A2&B2,A1&B2)
 
Top