LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
where text wraps in a cell, how can the row height be auto set? Stephen Sandor Excel Worksheet Functions 25 May 10th 10 07:57 PM
Can you create form in Excel & text wraps across several columns? quiana Excel Worksheet Functions 2 July 8th 06 07:25 PM
Not all text wraps in a cell containing large amount of text Kris Excel Discussion (Misc queries) 3 December 23rd 05 04:25 PM
Text import out of line? Krefty Excel Discussion (Misc queries) 3 December 21st 04 05:08 PM
Chart Label wraps on the same line. "Wavelenght [nm]" appears as. rog Charts and Charting in Excel 1 December 15th 04 08:10 PM


All times are GMT +1. The time now is 11:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"