Forum Discussion
Paste values-only Excel
I copy data from websites and different software and paste it into Excel 2019. The values are pasted correctly—without the currency symbol or extra space before the numbers—even when using "Paste Val...
"Paste Values Only" doesn't convert text to numeric values; it pastes content (aka value) "as is"
But assuming that source is in fact text, and therefore what's in your column C is also text, you can convert to value by entering in column D, =VALUE(C1) and copying that down. No need to search and replace the dollar sign and space.