Removing



Blank Cells

There are a number of different ways you can remove blank cells from a list


1) Using GoTo Special Dialog Box


2) Using Find (lookin 'values')


3) Using a Formula / Array Formula


4) Using a User Defined Function
RemoveSpaces - enter as an array formula returns an array to multiple cells
1
5) Using VBA Code
Range("A1").specialcells(xlcelltypeblanks).delete






Duplicate Cells





© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext