There are many techniques in Excel to Paste your data in Values. Let's see 4 of these techniques in this article
copy paste special value
How to copy only the formula and not the formatting of your document? In Excel you have 3 different techniques to do the job.
If you want to remove the extra spaces in a cell, there is a function for that ; it's the TRIM function. But you must convert your formula in values.