By combining To Go Special with Ctrl+Enter, you can fill thousands of empty cells with the correct data in seconds. First, ...

There's a certain kind of dread when seeing a massive block of text fill the formula bar in Microsoft Excel. When everything is crammed onto one line, your eyes skip over the mistakes that end up ...