Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. How do you copy from Excel (see 1 below) and paste into Word (2) WITHOUT seeing the filter button, gridlines, comment notes and more?

Guess and then view answer to see how it can be done!

2. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.

 

Replacing quotes in Excel

As shown below, occasionally when you import data from another system into Excel, the data you want is surrounded by quotes (“). If you try to Find/ Replace them or use a SUBSTITUTE or similar formula to get rid of them it doesn’t work. This is because you need to use a special trick when replacing quotes in Excel.

Replacing-quotes-in-Excel

YouTube Replacing quotes in Excel

Trick to get Excel to see the quotes

As shown above, even though you want to replace a single quote at a time, you need to put double quotes between the double quotes, i.e. to replace a single quote you actually need 4 quotes in a row i.e. “””” .

Excel’s new data cleanup tool

Data cleanup online course using only Excel

IF function not working with numbers