Hi,

If I have a list of names in excel such as
Craig Fox (A1)
John Jones (A2)

etc, how do I get excel to split the names into two columns, such as: -

Craig (B1)
John (B2)
in one column and in the same rows the surnames appear

Fox (C1)
Jones (C2)

I would like to do this to a long list of names

Matt