Hi All

I have a list of names which includes the Surname and First Name (with a
space in the middle).

Is it possible to split the list into two (one column for the first name and
one for the Surname).

As you would expect the names are all different lengths so I guess to need a
command to split where ever there is a space.

Any help greatly appreciated

Kind regards

Rexmann (using excel 2002)