Sub test()
Txt16Nb3R [B3]
End Sub
Sub Txt16Nb3R(ByVal Cel As Range)
Dim Txt As String
Txt = Replace(Cel.Text, " ", "")
Application.EnableEvents = False
Cel.Value = "'" & Left$(Txt, 16) & " " & Mid$(Txt, 17)
Cel.Font.Color = 0
Cel.Characters(Start:=18, Length:=3).Font.Color = &HFF&
Application.EnableEvents = True
End Sub