| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Softline break in cell
Hi,
I am trying to discover when either the data in a cell has exceeded the length of the cell (so it can not all be see or printed) or when a cell with wrap text set puts in a soft line break. Can anyone help me ? TIA Peter |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Softline break in cell
softline break within a cell - ALT ENTER
-----Original Message----- Hi, I am trying to discover when either the data in a cell has exceeded the length of the cell (so it can not all be see or printed) or when a cell with wrap text set puts in a soft line break. Can anyone help me ? TIA Peter . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Softline break in cell
"SW" wrote in news:0a3801c47b08
: Thanks but what character code do I search for in the string ? Peter softline break within a cell - ALT ENTER -----Original Message----- Hi, I am trying to discover when either the data in a cell has exceeded the length of the cell (so it can not all be see or printed) or when a cell with wrap text set puts in a soft line break. Can anyone help me ? TIA Peter . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Softline break in cell
Excel doesn't mark the break point with a character - at least there is no
way to search for one. -- Regards, Tom Ogilvy "Peter Longstaff" wrote in message . .. "SW" wrote in news:0a3801c47b08 : Thanks but what character code do I search for in the string ? Peter softline break within a cell - ALT ENTER -----Original Message----- Hi, I am trying to discover when either the data in a cell has exceeded the length of the cell (so it can not all be see or printed) or when a cell with wrap text set puts in a soft line break. Can anyone help me ? TIA Peter . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 Page Break Adjustments causes a page break each cell | Excel Worksheet Functions | |||
| How to line break in one cell via a formula to stack cell entries | Excel Worksheet Functions | |||
| Break cell into multiple lines by line break | Excel Discussion (Misc queries) | |||
| How can I break values apart that are in the same cell? | Excel Worksheet Functions | |||
| line break in a cell | Excel Worksheet Functions | |||
Linear Mode
