"Ron Coderre" wrote in message
...
With
A1:A10 containing text
B1:B10 containing your PROPER formulas

Try this:

Select the range of PROPER formulas (B1:B10)

From the Excel Main Menu:
<edit<copy
Select the first text value (A1)
<edit<paste special....Check: Values......Click [OK]
(now the formulas have been converted to their text values)

Then you can either delete the column with the PROPER formulas
or just erase those cells.

Does that help?
Post back if you have more questions.

Regards,

Ron
Microsoft MVP - Excel


perfect !
What a dope I am .
Thanks !
-keevill-