I have this string that a customer is sending us in a report. It looks like
the following.

COMPANY NAME; NAME; 11/22/04

I wanted to use the Text to Column feature, but every cell varies in length
and amount of data. I am curious if there is a way to search the cell and
strip out the date out of each cell and move them into a different cell on
the same row. Or can I setup a macro to copy the entire column, and then
strip out everything but the date. Any information that could be provided
would be greatly appreciated.

Thanks,