Softline break in cell

[Peter Longstaff]

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

 

[SW]

softline break within a cell - ALT ENTER

 

[Peter Longstaff]

[email protected]:

Thanks but what character code do I search for in the string ?

Peter

 

[Tom Ogilvy]

Excel doesn't mark the break point with a character - at least there is no
way to search for one.