Capture part of a text string

D

Dave

I have a column with entries like:

(NAV as of July 8, 2004,Price as of July 13, 2004)

I want to isolate just the:

July 8, 2004

How do I do this?
 
F

Frank Kabel

Hi
what do the entries have in common?.
- do they always start with 'NAV as of...'
- is there a fixed position fopr the date

You may provide some more data examples :)
 
N

Norman Harker

Hi Dave!

I think that the following will work OK:

=LEFT(MID(A1,12,255),FIND(",",MID(A1,12,255),12)-1)

I've tested on precisely the string given for months of May and
November.

If the string varies, it becomes more complicated.
 
Top