how about:

=MID(A1,LEN(A1)-10,11)&" "&LEFT(A1,DŁ(A1)-11)



On 19 Maj, 13:02, Martin ©¿©¬ @nohere.net wrote:
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
©¿©¬