Why don't you record a macro while you do it once to see what you end
up with?

Alternatively, you could consider using Data | Text-to-columns.

Hope this helps.

Pete

On Oct 11, 7:38 pm, Computer, call me if you have a problem
soft.com wrote:
I copy data into Excel from a website on the Web.

The only place I can find the Text Import Wizard option is in the paste
options box which is a drop down box that appears after I have pasted the
data into a cell.

The paste options box appears only after I have pasted and I have been
unable to call it up via a macro since the position of the box changes.

How can I call up the Text Import Wizard via keyboard or place it on a bar
so it is in a static position.