Bonjour Hello29, voilà une proposition:
Dim extraction as Variant
extraction = Split("paris/lyon/01/alo","/")
For i = lbound(extraction,1) to ubound(extraction,1)
Cells(1,i+1) = extraction(i)
Next i
il faudra remplacer
Split("paris/lyon/01/alo","/")
par
Split(Cells(x,y).Value,"/")
@Raja: Tu es vraiment rapide!