Help in excel

Occasional Visitor

I have a column with names. Surnames then forenames in one cell. No commas included. How do i change it so forename is before surname without manually typing all

1 Reply