Use =A1, then copy all the cells, then do editpaste special and paste as
values



--
Regards,

Peo Sjoblom


"showsomeidnow" wrote in message
ups.com...
hello, I have converted some cells from lowercase to uppercase using
the =PROPER formula (a list of countries that is). How do i reconvert
back to 'normal' text. I tried deleting the =PROPER prefix and leaving
just (A1) etc but then this is not correct as it shows up as A1, A2
etc in the formula bar. It should just show belgium, denmark, italy
etc - jut normal text! thanks all, really appreciate the help.