Private Sub Form_Load() Dim sData As String sData = "dsffdds1231456456" Dim i As Long For i = 1 To Len(sData) ' Debug.Print Mid$(sData, i, 1) Select Case Mid$(sData, i, 1) Case "1" Mid$(sData, i, 1) = "," End Select Next Me.AutoRedraw = True Print sData End Sub