Episode # 163 - Joining Text and Paste Special Values

Sponsored by

Check out this book for more tips
similar to this lesson!

Monday, January 09, 2006

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.

You don't need to go spend an entire day at the local computer chain store to learn Excel. Take 2 minutes to learn this lesson now with our free video!

Watch Video

Click Play icon to play the video. You might first need to click on the Video to activate Flash player.

Tags/Keywords for this video: Formulas

Episode # 163 - Joining Text and Paste Special Values

More Excel Video Lessons