Before delete -- Copy and paste special values. delete de column


hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"-keevill-" escreveu:

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.