Please Help! Delete all cells in range except "1934 - 1934"
I've been driving myself crazy trying to figure this out! I have a spreadsheet with a huge range of garbage cells, and I just need to extract the cells in a specific date format. IE: 1991 - 1995. A string of 11 characters (including spaces).
I am looking to delete all cells that do not fit that format and remove all blank cells.
Any help on this is greatly appeciated!
Thanks!
|