Use Paste Special to selectively paste only parts of what was copied.

On the Mac, Ctrl + C also works

The videos below demonstrate this shortcut.

Video thumbnail for How to clean text with CLEAN and TRIM

Video thumbnail for FILTER data between two dates

Video thumbnail for Create a dynamic reference to a named range

Video thumbnail for How to use absolute references - example 2

Video thumbnail for How to create a dynamic named range with INDEX

Video thumbnail for How to build a simple dynamic chart