frosty1
asked on
how to merge columns in calc
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 )
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 )
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
= a1 & ":" & B1 & ":" & c1 would work also and is less typing ;0)
kind regards
Eric
kind regards
Eric
ASKER
thanks for all comments, you were all obviously correct. Once i've got this formula i want to copy the data but when i copy the data it takes the formula with it. Can copy just the raw data
It is more about what is pasted. Try using "Edit-> Paste Special" and then choose values.
And place the formula at column D, if you want to hide the columns A, B and C you can hide them.