Help with Text Import Wizard

B

beth

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!!
 
G

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

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How to import text file into one column 4
Excel 2007 text import as text not date 3
Text Import Wizard 2
Import Data, using a command line switch 5
Importing text files automaticly. 5
Import txt files into Excel 7
Import comma delimited text 2

Top