View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Viktor Viktor is offline
external usenet poster
 
Posts: 2
Default how to find out if text in the Excel cell will be trancated?

Hi everybody,

Is there a way to find out if the text in the cell will not be
displayed completely (for inst., if text in A1 is 100 characters long,
it is going to be displayed in full only if the columns B1, C1, D1 etc
are empty, but if they are not, the text will not be displayed in
full).

I would like to know if there is a way to find out if the text is
going to be trancated without knowing if the neighbouring cells
contain anything.

Thank you!

Viktor