Excel 2007 : Macro, repeat keystroke

Hi,
I have a number of large tables that I have imported from a website. Unfortunately the text in the left column is such that if I import/paste special as text it makes it very difficult to get the data to columns.
The data in the table has a comma if it is more than 3 chars (e.g. 27,349) and does not read as a number.
So I need to go in and remove this comma.
As the record macro does not record the actual keystrokes I know I need a bit of scrip that does something like this: move across 3 characters,backspace, enter.

I have managed to run & test some script and the closest to my solution looks like this:

With ActiveCell
If Len(.Value) > 3 Then
.Value = Left(.Value, Len(.Value) - 2)
.Offset(1, 0).Select
End If
End With
End Sub

But that just deletes the last 2 characters. I don't understand what these formulas are really saying.

Any help is appreciated!

Thanks,
Graeme