[Solved] Paste Special - Values

Stargazer76 · Post by **Stargazer76** » Tue Feb 15, 2011 6:52 pm

How do I copy the values (results of formula) to a new cell?
Thank you!

I have numbers in column A with a leading ' so I did a TRIM formula to remove it, results are in column B.
I want to work with the values as numbers (no formula). In excel I would have done a Paste Special - values option and
pasted the results to column C.
I do not see anything like this (values) in the paste special options.
Thanks again

edit this topic's initial post · Post by **Villeroy** » Tue Feb 15, 2011 7:07 pm

Use the insert key or Ctrl+Shift+V, unselect what you don't want, select what you need.

edit this topic's initial post · Post by **Villeroy** » Wed Feb 16, 2011 3:55 pm

I have numbers in column A with a leading ' so I did a TRIM formula to remove it, results are in column B.

TRIM returns text. You should use VALUE(TRIM(xxx)) or just VALUE(xxx), then paste special numbers.

Stargazer76 · Post by **Stargazer76** » Wed Feb 16, 2011 8:33 pm

Thanks Villeroy - that works perfectly and will save me a ton of keying!

[Solved] Paste Special - Values

[Solved] Paste Special - Values

Re: Paste Special - Values

Re: Paste Special - Values (Not solved)

Re: Paste Special - Values (Solved)