Swaping order of names in Cell , creates a leading space

[Godders199]

Hello, i want to use the following formula to swap the order of names within a cell, however it is creating a leading space, before the first name.

=MID(A2&" "&A2,FIND(",",A2)+1,LEN(A2))

I know the Trim function can remove this, but not sure how to combine into this formula.

So my question is firstly, is there a reason my current formula creates the leading space?, secondly if my formula is correct how do i combine the Trim function ?

Thanks for your help.

 

[gallen]

just wrap the whole thing in Trim

As to why, I could only guess as I don't have the live data.

=TRIM(MID(A2&" "&A2,FIND(",",A2)+1,LEN(A2)))

 

[FormR]

Again, without any sample data it's a guess, but maybe an alternative.

=MID(A2&" "&A2,FIND(",",A2)+2,LEN(A2)-1)

 

[Godders199]

thanks for your help .. much appreciated