I have something like "9/12/03 Joe Average" in several
cells (dates and names are different of course). I would
love to be able to write a macro or routine that
eliminates everything after the first space, leaving only
the date.

I can definitely do this the "long way" by inserting an
empty column and then combining the MID and LEN functions,
then using copy, paste special (values) and then deleting
the original column.

However, I just thought there might be a quicker way by
using VBA code by using something like:

ActiveCell.Characters.Delete

But I guess I would need some sort of MID and LEN formula
in there to help me know WHAT characters to delete. Is
this method worth exploring?? Can anyone assist?

Thanks in Advance,
Don