place the following in your cells
and use copy, paste-value onto itself and so on
this will allow for variable name length

=TRIM(LEFT(A1,19))
=TRIM(RIGHT(LEFT(A1,LEN(A1)-27),(LEN(LEFT(A1,LEN(A1)-27))-LEN(B1))))
=TRIM(RIGHT(A1,LEN(A1)-(FIND("Date: ",A1)+5)))

"Lindsey M" wrote:

Hi,

I have a report that I need to sort through to be left with raw data that
can then be exported into access and manipulated. The problem I'm having is
that the report is exported from another program and the data is put into
single cells which is no good.

I need to split the following into single cells for exporting:

Evaluation Title: 14.02.05 @ 11:03:59 Smith Evaluation Date: 22 Feb 05
Evaluator: Lindsey Martin

This needs to be split so that i'm left with three cells, i.e. data from
Evaluation Title, Evaluation date and Evaluator.

I've been working on this for while now and I'm getting nowhere so any help
would be greatly appreciated!

Cheers
Lindsey