I would like to achieve the following using VBA:
Go thru column B of the (used range of the ) active worksheet and look for text entries (numbers formatted as text do not count).
If found move up one cell and delete the contents of that cell. Do Loops.
Help is much appreciated. Thank you very much in advance.
I have attached a sample file for your convenience with detailed explanations.