Hello,

I have a long list of names that I want to break down into
Surname/Forenames. I have used an IF statement to get out the surname after
using Text to Cols to breakdown the data. I now need to separate out all
other names - any idea how to do this?
Some sample data:

Surname Forenames
AGNEW ROBERT E AGNEW
HYDE W H S HYDE
KEYS RICHARD KEYS
LYONS WILLIAM JOHN LYONS
PRICE HAROLD PRICE
BOYD SUSAN ELIZABETH ANN BOYD

Thanks,

Charlotte