I have a list of names and addresses in columns and have used the
=PROPER(A1) command to change the allcaps columns to be correctly
capitalised words .
Question is how can I just remove the columns which are allcaps and just be
left with the correctly capitalised ones?
Using the formula above, of course I cannot delete them as the formula is
dependant on the existence of the original.