Hello,
J'utilise liveboxinfo pour sortir la chaine d'authentification ... et j'en ai eu marre de rajouter les : à la main.
Donc direction Excel et une petite macro pour faire le job.
Code ci-dessous et fichier excel en PJ.
Entrez votre chaine en cellule A1 ... la marco a ajouter un ":" tous les deux charactères.
Sub chainelivebox()
Dim Rng As Range
Dim InputRng As Range, OutRng As Range
Dim Row As Integer
Dim Char As String
Dim Index As Integer
Dim arr As Variant
Dim Val As String
Dim OutVal As String
Dim Num As Integer
xTitleId = "Add a character"
Set InputRng = Application.Selection
Set InputRng = Cells(1, 1)
Row = 2
Char = ":"
Set OutRng = Cells(2, 1)
Num = 1
For Each Rng In InputRng
Val = Rng.Value
OutVal = ""
For Index = 1 To VBA.Len(Val)
If Index Mod Row = 0 And Index <> VBA.Len(Val) Then
OutVal = OutVal + VBA.Mid(Val, Index, 1) + Char
Else
OutVal = OutVal + VBA.Mid(Val, Index, 1)
End If
Next
OutRng.Cells(Num, 1).Value = OutVal
Num = Num + 1
Next
End Sub