Learn Excel Episode 163: Joining Text and Paste Special Values
Have you ever deleted a column, only to find out that all of the formulas in another column change to REF! errors? Sometimes, you enter a formula, but then need to convert the formula from a formula that will calculate to static values (so that you can delete the columns upon which the formula is based). This is possible, using the Values option on the PasteSpecial dialog.Also in Episode 163 - using Ctrl+Z to undo and using the ampersand to join text.