Remove spaces in Excel with the TRIM function
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.
copy paste special value
Copy the formula and not the formatting in Excel
How to copy only the formula and not the formatting of your document? In Excel you have 3 different techniques to do the job.