Sub extractioncol()
'
' extractioncol Macro
' Macro enregistrée le 19/03/2014 par N122640
'
Dim lCol As Range
Dim lCel As Range
Dim wks As Worksheet
Set wks = Sheets("donnes")
Set lCol = Range(wks.Cells(2, 2), _
wks.Cells(wks.Cells.SpecialCells(xlLastCell).Row, 2))
' ou Set rCol = Range(wks.Cells(1, 1), wks.Cells(65535, 1).End(xlUp))
For Each lCell In lCol
lCell.Offset(0, 1) = Left(lCell, 3)
Next lCell
'
End Sub