Copy text only, not formula
 

I'm trying to convert a huge list to all capitals. if I use the Upper
formula, how can I copy the text after it's converted and move it to a new
spreadsheet? If I move it now, it copies the formula. I want to be able to
copy the text after it's converted only. Any Ideas? Thanks in advance.

Copy text only, not formula
 

hi
after coping the upper formula, select where you want to paste.
on the menu bar, editpastespecialvaluesok
this will convert the formula into hard data.

Regards
FSt1


"myk in ny" wrote:

I'm trying to convert a huge list to all capitals. if I use the Upper
formula, how can I copy the text after it's converted and move it to a new
spreadsheet? If I move it now, it copies the formula. I want to be able to
copy the text after it's converted only. Any Ideas? Thanks in advance.