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)

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

Awesome, it worked!! Thank you, Sean Timmons :D

"Sean Timmons" wrote:

Will it always be the way you've listed?

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

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

Sometimes I get lucky. :-)

"Tacrier" wrote:

Awesome, it worked!! Thank you, Sean Timmons :D

"Sean Timmons" wrote:

Will it always be the way you've listed?

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

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

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Tacrier" . wrote in message
...
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..

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