Hi

Have a look at Data/Text To Columns. As long as the format is fairly
standard, this will do the job. You could do it using formulas, but it's
worth checking out the above first.

--
Andy.


"Kate Was Here" wrote in message
...
Hi there
Does anyone know a function which is the reverse of concatenate. I have a
field which is first name and last name and I'd like them in separate
fields.
Is there a way of doing it?
Any help gratefully received.
Kate x