Sub Résultat()
Dim colA, colC, i As Long, t As String
colA = Range("A2:A3", Range("A" & Rows.Count).End(xlUp)) 'au moins 2 éléments
colC = [C2].Resize(UBound(colA))
For i = 1 To UBound(colA)
t = UCase(Left(colA(i, 1), 35)) 'majuscules
colA(i, 1) = t & String(35 - Len(t), " ")
Next
'---restitution---
With Sheets("Résultat")
.Range("A2:B" & .Rows.Count).ClearContents 'RAZ
.[A2].Resize(UBound(colA)) = colA
.[B2].Resize(UBound(colC)) = colC
.Activate
End With
End Sub