Ask Your Question

how do I merge columns in Calc? [closed]

asked 2012-11-15 15:18:17 +0200

Chris Vella gravatar image

I would like to paste the contents of two columns into one column with just a space or a dash in between in between. How do I do that?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-18 23:06:09.541958

1 Answer

Sort by » oldest newest most voted

answered 2012-11-15 15:41:26 +0200

Edward gravatar image

Assuming Text in B1, C1, and D1, you can join the data in cell E1: =B1 & " " & C1 & " " & D1 Text between quotation marks will appear literally. In this example the output will have blank spaces, but you can use this to insert commas, dashes, etc

edit flag offensive delete link more


How can I do the same with contents of those columns , If the column values are equal to each other , then it has to merge,,, can it be done or what?

SudhirBelagali gravatar imageSudhirBelagali ( 2016-05-09 10:42:16 +0200 )edit

Question Tools


Asked: 2012-11-15 15:18:17 +0200

Seen: 22,258 times

Last updated: Nov 15 '12