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.
This new blog is the video podcast companion to the new book, Learn Excel from MrExcel. Download a new two minute video every workday to illustrate one of the 277 tips from the book!