This about the problem of cells which appear to be blank and which are true blanks. If you check a cell using IsBlank() formula, you’d know if it’s a true blank or not. Even if you copy paste special (values) this =””, there wouldn’t be anything in the cell and length of that cell would […]
Continue readingSteps to get your bookmarks in a database format First way: Open Excel>Data>Import External Data>New Web QueryPaste the address of your bookmark on your hardisk in the web query addressSelect the tableImport it to ExcelYou’ll see first column has all the addresses of the links, and after few columns the text for that hyperlinkPress Ctrl […]
Continue reading