If dates are always nine characters long then use this:

=MID(A2,FIND(":",A2)+2,9)


"Tacrier" wrote:

Hi,

I have a column with a text string in each cell like this:

Smith, John (DOB: Sep 10/45)
Strawberry, Kathy (DOB: Jan 01/72)
Cadbury, Nolan (DOB: Feb 21/54)

I would like to remove the date only ie. Sep 10/45 from the text string and
put into another cell. As you can see the names in each subsequent cell vary
in length. What formula can I use to do this?

Thanks so much..