isolate date from a text string into another cell

  • Thread starter Thread starter Tacrier
  • Start date Start date
T

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..
 
Will it always be the way you've listed?

=MID(A2,FIND(":",A2)+2,FIND(")",A2)-FIND(":",A2)-2)
 
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.
 
If dates are always nine characters long then use this:

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