You seem to have picked up the right macro although my link was slightly
incorrect

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

is the right link to the macro


Peo


"Hannah" wrote in message
...
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!