Run this macro
http://www.mvps.org/dmcritchie/excel/join.htm
same website also has instruction to install macros
note that sometimes date values converts to their raw serial numbers, the
values are still the same but you need to format them as dates again just
for display, for instance Apr 12th 2006 has a serial of
38819
--
Regards,
Peo Sjoblom
http://nwexcelsolutions.com
"Hannah" wrote in message
...
I export a report from a customer on the web. Their worksheet contains a
delivery schedule that I must compare to my schedule. I need to use a
formula
to calculate the 20th day prior to their on dock date. The dates on their
worksheet have 2 additional unneeded spaces in the beginning of the date
(in
each cell). I need to remove these spaces in order to format the cells and
then use a formula. I have tried everything from "Find & Replace" to
retyping
each individual date. (There are about 2000 dates on this report).
Please help!