Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
divide multiline text cell across several rows
Say I paste text data (essentially a sentance(s) ) into B2,
where Col B has a columnwidth of 55 and the RowHeight is set to 12.75. I then enable Wraptext in this cell, and the RowHeight now increases to 51 (so the data is occupying 3 + lines in the cell). I save the workbook, close it, then reopen it. Is there a way to reformat the data in B2, so that it will then occupy 4no 12.75 high rows in colB? I believe the data will only be space delimited. Regards. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.661 / Virus Database: 424 - Release Date: 19/04/2004 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Textbox and multiline text | Excel Worksheet Functions | |||
DIVIDE CELL INTO TEXT BOXES | Excel Discussion (Misc queries) | |||
import multiline data from text file | Excel Discussion (Misc queries) | |||
Fixing multiline cell | Excel Worksheet Functions | |||
embed <alt<enter for multiline cell in a CSV file | Excel Programming |