One way, with a formula (assumes the value is in cell A2):

=LEFT(SUBSTITUTE(A2," ",""),LEN(SUBSTITUTE(SUBSTITUTE(A2," ","")," ",""))-3) & " " & RIGHT(SUBSTITUTE(A2," ",""),3)

It removes any spaces and then puts a space back in three characters from the right.


Regards