Text import with line wraps
 

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.

Text import with line wraps
 

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 wrote:

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

Text import with line wraps
 

"Dave Peterson" wrote:

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 wrote:
Thanks David, I can see that will probably work. I was hoping to not actually have to touch it all after the import, but this is better than nothing and preserves the control I want as to what wraps where!!