I was asking if the original data was in one column.

And from your reply, that one cell (A1) isn't enough to tell.

(The Data|Text to columns will put things in separate columns.)

Lindsey M wrote:

Hi Dave

No, not a single column of data, it starts with

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

all in one cell, e.g. A1. I want to split the info so that i have the
following

B1 = 14.02.05 @ 11:03:09 Smith
C1 = 22 Feb 05
D1 = Lindsey Martin

And for the original cell (A1) to be cleared or (preferably) deleted.

I hope this makes more sense :)

Lindsey

--

Dave Peterson