Formula for making Text Proper worked - but how do I transpose it to correct column?

I used the =PROPER(x#) formula to turn a 1500 line worksheet into proper case instead of some all uppercase, some all lower case. My problem: the program I am importing this list to must have the columns in a specific order. The corrected fields are to the far side (blank area) of the worksheet. The columns it got the info from to correct are still incorrect, but in the right place. I can't copy and paste without ruining the formula. I can't do the formula directly into the correct columns.

So how do I make the correct Proper case text (corrected by using the formula) insert itself into the correct columns?

Thanks for any assistance! I know there has to be an answer but I've spent an hour looking for the answer.

Hi,

if you only need to do it once, you could copy the corrected columns and then use paste special - values to overwrite the original (wrong) columns.

HTH

Teylyn