| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i copy the actual text of a formula? | Excel Discussion (Misc queries) | |||
| How do I copy text formatting using a formula? | Excel Discussion (Misc queries) | |||
| Copy formula so destination displays formula as text | Excel Discussion (Misc queries) | |||
| How can I copy and paste the text of a formula? | Excel Worksheet Functions | |||
| How to copy a formula as text to another cell? | Excel Discussion (Misc queries) | |||
Linear Mode
