Selecione as células que você deseja converter e execute esta macro curta:
Option Explicit
Sub One_ification()
Dim r As Range, v As String
Dim L As Long, i As Long, CH As String
For Each r In Selection
v = r.Text
L = Len(v)
For i = 1 To L
CH = Mid(v, i, 1)
If CH Like "[0-9]" Then Mid(v, i, 1) = "1"
Next i
r.Value = v
Next r
End Sub
Antes:
edepois: