This question is for open office calc, but i think excel users would probably be able to help
I wish to merge A1 - C1. I want to do this to all rows ( i have 2000 ). I believe this has to be done with a formula. I found the below. The only thing is i don't know how to implement this. ie where do i put the formula. And what cells do i select.
=CONCATENATE( A1; ":"; B1; ":"; C1 )