Capture part of a text string

[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?

 

[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

 

[Dave]

Thanks. Just solved my problem...

=MID(A15,12,FIND("P",A15)-1-12)

 

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