is useful when you've used formulas to assemble information. A regular copy/paste will include the formulas, but a paste special allows you to paste the values generated by the formulas.
pastespecial.mp4
» Excel Functions for Reformatting Data Files (CSV)
