Help with Text Import Wizard



I am importing some data shown as a table in my email however when I transfer
it to a Word or Excel document it becomes a single column of text with each
column of information separated by a new line. I need to change it to a table
in Excel however when I try to use the Text Import Wizard it does not have an
option to classify each column by a new line only by a space, comma etc. Is
there any way I can change it to recognise a new line?


Gord Dibben

In the "Other" box try CTRL + j or Alt + 0010(on numpad)

Gord Dibben MS Excel MVP

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question