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
5) Using VBA Code

Duplicate Cells

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