I have a list of names in one column, all of which are different lengths,
which I want seperating into different columns e.g.

Smith John Mr Mr John Smith
Johnson Pauline Miss Miss Pauline Johnson

Any ideas?

Regards,

Nick