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.