That was awesome! Thank you so much! I have been working on this for 2 weeks!

Thanks again!

"Peo Sjoblom" wrote:

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!