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


Gord Dibben MS Excel MVP

On Tue, 22 Apr 2008 18:31:01 -0700, beth wrote:

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?

Thanks!!