| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| where text wraps in a cell, how can the row height be auto set? | Excel Worksheet Functions | |||
| Can you create form in Excel & text wraps across several columns? | Excel Worksheet Functions | |||
| Not all text wraps in a cell containing large amount of text | Excel Discussion (Misc queries) | |||
| Text import out of line? | Excel Discussion (Misc queries) | |||
| Chart Label wraps on the same line. "Wavelenght [nm]" appears as. | Charts and Charting in Excel | |||
Hybrid Mode
