Delete Entire Row If No Data Is Found
These piece of code lets you delete an entire row within the used range of the sheet if the entire row contains no data.
Recent posts
Create Sheets From Cell Values
This is one of my favourites and I use it all the time. Type a bunch of sheet names in a list of cells, select those cells then run this macro.
Extract Link Address From (insert)hyperlink Or Hyperlink Formula
This method that will return the hyperlink text whether it has been created by a formula, or by the Insert/Hyperlink method.
Word Count From Cells
There’s no built in way to count the number of words in Excel, but using the following formulas will get it done.
Extract Nth Word From A String
If you need to get the nth word in a text string (i.e. a sentence, phrase, or paragraph) you can so with a clever (and intimidating) formula that combines 5 ...