It depends on the date and your cell is structured. You may be able to use
VBA's Left, Right, or Mid functions to extract the substring that contains
the date and then place that substring in another cell.

"Mikey" wrote:

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,