Big problem
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
|