Hi
is this date always at the same position?

--
Regards
Frank Kabel
Frankfurt, Germany


Ana wrote:
Hi everybody!

My problem is : I get data from internet in a sheet, I
have to do it every day. I have in cell A1 the following
sentence :

Daily Returns for Major Fixed Income Indexes for May 21
2004 in EURO Terms

and I need the date , every day there will be a diferent
date ; My problem is to obtain from that text the exact
date in a date format .. How can I do it ?
I have tried to use formules like right and left , but as
is a variable text , I do not get always the excact date
and of course it is not in a date format .

anyone have any idea ??
Thanks a lot
Ana