Hi Andy,
I'm also trying to do something similar--split a field called Contact that
has Title First_Name Last_Name into three separate fields. However mine is a
little more complicated because the Contact field is messy (sometimes Title
exists, sometimes it's only Last Name, etc). Could you explain how you can
do this with formulas, as you mentioned in your post?

Thanks for your help.
-Steven S

"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