Hi,

Name
=TRIM(LEFT(A1,FIND("(",A1,1)-1))

DOB
=TRIM(MID(A1,FIND("(",A1,1),LEN(A1)))

Mike

"Tacrier" wrote:

I tried unsuccessfully to isolate text immediately preceding the "(" from a
text string into another cell using:

=MID(A1,SEARCH("(",A1) -20)

My text string contains a payee name followed by their date of birth like
this:

Smith, John (DOB: Dec 16/91)

I want to put the name into cell A1 and the DOB into B1, however I want to
do this for about 100 rows and each row has different text string lengths due
to the varying name lengths.

Any suggestions?

Thanking you in advance,
Trina