Have you ever had difficulty selecting and replacing blank cells with other words/numbers in excel? Well, I have. I had data of more than 2,000,000 and I found it extremely difficult to replace manually (one by one).
Imagine the time I would have spent searching for each blank cell and typing or pasting the new text. Well here's a help for Microsoft Excel 2007 users.
The other helpful hints from other forums (like this link)did not work on my excel sheet. I don't know why. Using "Go to - Special...-Blank cells" (Ctrl + G) does not seem to select the blank cells. It just says, "no cells were found!"
Even the "Microsoft Excel Help" wasn't able to help me! Quite ironic but it really didn't.
Here is another easy way of replacing those blank cells! Just follow these simple steps.
