ok, here is a tough one i think. I have a file that i copy into excel every
day. while all the information is the same, in the B column there is a random
amount of spaces included by the program that gives me the data. Thanks to
Dave i now have a macro that I can use to compare two sheets for duplicates,
problem is that its not finding the duplicates due to the different number of
spaces.. anyone know how to make a macro that removes all the spaces? the
values in the B columns are all different lengths.