Re: Another one for the Excel gurus
Ooooh, another idea - find and replace, replace all spaces with a comma? Then export as a CSV and you've now got first and second names (assuming no middle names, no names which incorporate a space etc) as seperate columns?
|