=RIGHT(A2,LEN(A2)-FIND(" ",A2))&" "&LEFT(A2,FIND(" ",A2)-1)
--
David Biddulph

<Martin ©¿©¬ @nohere.net wrote in message
...
Hi
I have the name McAllister Mr & Mrs E.
When I use text to columns it becomes Mr & Mrs E.McAllister
However, I want it to be Mr & Mrs E. McAllister
(with a space between E. & McAllister)

How would I do that please?
--
Martin
©¿©¬