You're using Excel 2000, so perhaps the Text To Columns syntax I recorded is slightly different.

Use your macro recorder to record your actions as you apply the text to columns to the column A data the macro I gave you created. Then put that recorded macro in place of the blue code originally gave you.

Post up your version of the blue code so I can see the difference, if you don't mind.