Sub Test7()
Dim arr, i%
With Sheets("sheet1")
arr = .Range("a1:a" & .Range("a65536").End(xlUp).Row)
End With
For i = 1 To UBound(arr)
If InStr(arr(i, 1), ".") Then arr(i, 1) = Left(arr(i, 1), InStr(arr(i, 1), ".") - 1)
Next i
[b1].Resize(UBound(arr), 1) = arr
End Sub