Yes, the text does start with a day followed by a comma followed by a single
space.
I've tried the formula you suggested again but have excluded the DATEVALUE
section (so I've entered 'RIGHT(A1,LEN(A1)-FIND(" ",A1,1))'), which gives the
result of:

June 15, 2008

As soon as I include the DATEVALUE, I get the #VALUE! result.

I've tried it on a new spreadsheet and a new session of Excel, just in case
there was a problem with the source data.

"Gary''s Student" wrote:

The formula will work if the text starts with a day followed by a comma
followed by a single space. Which is what your example shows.
--
Gary''s Student - gsnu200793


"Sarah (OGI)" wrote:

Thanks for your prompt response, but I'm getting a #VALUE! result. Any ideas
why this might be?

"Gary''s Student" wrote:

With your value in A1 use:

=DATEVALUE(RIGHT(A1,LEN(A1)-FIND(" ",A1,1)))

and format it as you choose
--
Gary''s Student - gsnu200793


"Sarah (OGI)" wrote:

I've received a report whereby column A shows a list of dates.
Unfortunately, it seems that the date is written in a 'general' format and
looks like this:

Sunday, June 15, 2008

Is there an easy way to convert this into a date format, i.e. dd/mm/yy?