how do I merge columns in Calc? [closed]

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

Chris Vella
241 ●15 ●19 ●28 http://jesuit.org.mt/

updated 2020-07-22 08:42:00 +0100

flag of United Kingdom of Great Britain and Northern Ireland

20859 ●19 ●60 ●59 http://etmg.altervista...

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

add a comment

1 Answer

Sort by » oldest newest most voted

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

Edward
637 ●12 ●18 ●26

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

Comments

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 ( 2016-05-09 10:42:16 +0100 )edit

add a comment

Question Tools

Stats

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

Seen: 26,641 times

Last updated: Nov 15 '12

how do I merge columns in Calc? [closed] edit

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