concenate and deleting formulas....help pls

[omegadeltaphi]

I merged two columns..............so now i dont need the first two columns.

How can I keep the information in the merged column and get rid of the
first two that are repetitive now that i have the merged column. Without messing up the formula stuff in the concenated column.



I need to print this and its a huge file....ink=$

Please help
thx in advance
Steve

 

[sfshah]

You cannot delete the source data columns on which the formulas depend.
If you want to still delete them but keep the results of the formulas, select the merged column range, copy it and then select paste special from edit, select values, click ok. You will loose the formulas, but retain the results.
Satish