How to delete old columns after merging?

General discussion on OpenOffice Calc and its spreadsheets.

How to delete old columns after merging?

Postby Jalium » Thu May 29, 2014 9:46 am

Hello,

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.
Beginner here..is there any way to create a new column with all the data and then delete the old columns?

Thanks.
Jalium
 
Posts: 20
Joined: Tue Mar 25, 2014 6:26 am

Re: How to delete old columns after merging?

Postby Champ_AN » Thu May 29, 2014 11:44 am

Hi,

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 think this is a better solution to fix this problems.

Thanks,
Champ_AN
 
Posts: 19
Joined: Tue Mar 25, 2014 6:34 am


Return to OpenOffice.org Calc

Who is online

Users browsing this forum: No registered users and 0 guests

cron