Thanks for the feedback! Glad to help.

--
Andy.


"Kate Was Here" wrote in message
...
Brilliant.
Thank you!

"Andy B" wrote:

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