Once you find the year, you can use left to pick up the rest of the
date:
=LEFT(L1,FIND("As",L1)-2)


On May 5, 11:49 am, Peanut wrote:
I have a spreadsheet with a daily import tab. In this daily import, there is
a cell with the date as "April 4, 2006 As of 2:00 PM ET". I am trying to
extract the date of the imported worksheet for display on another page.
Because of the dynamics of this spreadsheet, Text To Columns will not work
for me.

Is there an easy way to extract the information since the lengths of the
month and date may vary? I got the year by

=--MID(L1,FIND(", ",L1)+2,4)

But I'm not sure how to obtain the other information. Please help.