Copy text only, not formula

  • Thread starter Thread starter myk in ny
  • Start date Start date
M

myk in ny

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.
 
hi
after coping the upper formula, select where you want to paste.
on the menu bar, edit>pastespecial>values>ok
this will convert the formula into hard data.

Regards
FSt1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Move or Copy Stopped Working? 0
Calculate number of rows and apply formula 4
Row #s Not Advancing When I Copy Formula 2
How Can I Convert MBOX to HTML File? 0
Copying defaults 1
formula to count text entries and return text with most entries 8
convert xls file to word doc 1
I can't copy and paste equations 0

Back
Top