Highlight the column, then Data TextToColumns Delimited and use space
for the delimiter......

Vaya con Dios,
Chuck, CABGx3



"mattguerilla" wrote:

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