Importing text into Excel...
"Tim M" wrote in message
...
Greetings, I have some reports generated as .RTF files, I can open them
and
save them as .txt files for import into Excel.
With the text import wizard you can create line breaks thus separating
data
into columns. However since I have some large text descriptions in the
file
I want to have numerous lines be imported into the same row. Presently it
sticks one line of text into each separate row. Is this possible or am I
missing something obvious?
Thanks for any help.
If I'm reading your question correctly, it seems that once these long
descriptions are in Excel, they're forcing overly large column widths,
right? How about Format, Cells, Alignment, Wrap?
|