Text import with line wraps

[HKAPGMR]

Hi all,

I have a tab delimited file that I create, which I will open and import into
Excel. Some of the fields are very wide, so I want to embedd characters that
will force a line wrap when Excel imports the file. I have tried embedding
hex 0A (char (10)), as one might in an Excel formula, but that just forces
new cells, like a tab (char(09)) would.

Thanks all.

 

[Dave Peterson]

I'd use a unique character--one that's never used anywhere else (maybe the
vertical bar |).

Then I'd import the text file and add a couple of steps
#1.
Select all the cells
edit|replace
what: |
with: (alt-enter)
replace all

Hold the control key while hitting the j key. You may not see anything, but try
it. ctrl-j is the same as alt-enter or =char(10) or vblf or ...

#2. If you see a small square where that | was, you'll have to change the
format:
Select the range to fix
Format|cells|Alignment tab|check Wrap Text

 

[HKAPGMR]

I'd use a unique character--one that's never used anywhere else (maybe the
vertical bar |).

Then I'd import the text file and add a couple of steps
#1.
Select all the cells
edit|replace
what: |
with: (alt-enter)
replace all

Hold the control key while hitting the j key. You may not see anything, but try
it. ctrl-j is the same as alt-enter or =char(10) or vblf or ...

#2. If you see a small square where that | was, you'll have to change the
format:
Select the range to fix
Format|cells|Alignment tab|check Wrap Text