1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
|
Function numer(x As String) As Variant
Dim v As Variant
Dim rep As Variant
Dim ou As Integer
ou = 1
rep = Mid(x, 1, 1)
Do Until IsNumeric(rep) Or ou = Len(x)
ou = ou + 1
rep = Mid(x, ou, 1)
Loop
If IsNumeric(rep) Then
Do Until Not IsNumeric(Mid(x, ou + 1, 1)) Or ou = Len(x)
ou = ou + 1
rep = rep & Mid(x, ou, 1)
Loop
numer = rep
Exit Function
Else
numer = v
End If
End Function
Function pasnumer(x As String) As String
Dim u As Variant
u = numer(x)
If IsNull(u) Then
pasnumer = x
Else
pasnumer = Left(x, InStr(1, x, u) - 1) & Right(x, Len(x) - InStr(1, x, u) - Len(u) + 1)
End If
End Function |
Partager