John...

You can highlight, say, a column and do a COPY command (alt C or Edit/Copy), then highlight the space to which you want to COPY the data, then right-click and select PASTE SPECIAL... then click VALUES ONLY. Voila! You can then delete the formula column altogether.