Bonjour et
Function coder(cel As Range)
coder = "": texte = cel.Value: prov = "": nb = 0
For i = 1 To Len(texte)
If prov = Mid(texte, i, 1) Then
nb = nb + 1
Else
If prov <> "" Then coder = coder & nb & prov
prov = Mid(texte, i, 1): nb = 1
End If
Next
coder = coder & nb & prov
End Function