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:

Please Login or Register  to view this content.

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

Any help is appreciated!

Thanks,
Graeme

Please take a few minutes to read the forum rules, and then edit your post to add code tags.

Thanks.

Why not use the Find and Replace feature built into Excel? No VBA required and it is very fast and easy.

Click the column header, press Ctrl + H, click the Replace tab and type a comma in "Find What" box. Leave the "Replace with" box blank.

Please Login or Register  to view this content.