isolate date from a text string into another cell

[Tacrier]

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..

 

[Sean Timmons]

Will it always be the way you've listed?

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

 

[Tacrier]

Awesome, it worked!! Thank you, Sean Timmons

Will it always be the way you've listed?

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

 

[Sean Timmons]

Sometimes I get lucky.

Awesome, it worked!! Thank you, Sean Timmons

 

[RagDyer]

Use TTC.

Select the data, then from the Menu Bar,

<Data> <Text To Columns> <Delimited> <Next>

Click in "Other", and then type in the left quotes (

You'll see your data displayed separated in the Preview Window below.

Click <Finish>
And you"ll have your data split into 2 columns.

You can play around with the settings to get different displays.

Post back with any questions.

 

[Teethless mama]

If dates are always nine characters long then use this:

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