You need to paste it in first, then use data=Text to Columns to do the same
as you describe. If do it that way with the recorder on, you will get the
code you need.

--
Regards,
Tom Ogilvy


"Moo" wrote:

I am trying to create a very basic macro in Excel, but keeping coming
unstuck and hope someone can help.

I am trying to copy some text fields from an old DOS based programme
into Excel. If you simply copy and paste, the text will copy itself
into one cell only as a long string of text.

I want to separate this text into different columns; the manual way of
doing it is to click on paste options, use text import wizard, setting
the columns as fixed width. I have tried recording this as a macro,
but it is not working at all.

Any suggestions on a basic macro to copy this data in as separate
columns?

Thanks.