Link to home
Start Free TrialLog in
Avatar of frosty1
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 )

Avatar of sithunml
sithunml
Flag of Myanmar image

Insert new column between C and D if you have data in column D
And place the formula at column D, if you want to hide the columns A, B and C you can hide them.
ASKER CERTIFIED SOLUTION
Avatar of kevb258
kevb258

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
= a1 & ":" & B1 & ":" & c1 would work also and is less typing ;0)


kind regards

Eric
Avatar of frosty1
frosty1

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.