How to delete old columns after merging?

General discussion on OpenOffice Calc and its spreadsheets.

How to delete old columns after merging?

Postby Keya_LOT » Fri Jun 13, 2014 7:07 am


I've merged three columns together in one new column, now how do I delete the three old columns without deleting the data?
I used =CONCAT(M2;" ";N2;" ";O2;) in column P and it worked fine, but the data in P now refers back to the old un-concatinated
columns M, N, O and I can't get rid of them without deleting the data in P.
Is there any way to create a new column with all the data and then delete the old columns?

Thanks In advance.
Posts: 24
Joined: Tue Mar 25, 2014 6:35 am

Re: How to delete old columns after merging?

Postby FriedL » Fri Jun 13, 2014 9:51 am


In Windows I would do a copy, then Paste Special, with everything except Paste All and Formulas checked.
I'm referring to the information in column P.
Once that is done, then you can delete the other columns, since P isn't using a formula that relies on the other columns.

I hope this will help you..
Posts: 15
Joined: Mon Mar 24, 2014 5:49 am

Return to Calc

Who is online

Users browsing this forum: No registered users and 1 guest