Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to find out if text in the Excel cell will be trancated?
inexact, but the
if len(Range("A1")) Range("A1").ColumnWidth then msgbox "Possiblity text is wider than column" End if Columnwidth is measured units of character width: One unit of column width is equal to the width of one character in the Normal style. For proportional fonts, the width of the character 0 (zero) is used. Regards, Tom Ogilvy "Viktor" wrote in message om... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to find out if text in the Excel cell will be trancated?
Hi Tom,
Thanks a lot for your reply. However, it does not solve my problem. I know how to figure out if the text is larger then the column, but that does not mean that it will be trancated: if, say, the next couple of columns are empty, it will be displayed in full. How can I know if the text is going to be trancated without checking if there is anything in B1 or C1? Of course, I can loop through columns (B1, C1, D1 etc) to see if they are empty and if not, see if their total width is more then the text width in A1, but that would mean a lot of extra processing. What I was hoping for, is that there is some kind of a property for a text in A1 that would indicated if A1 text is going to be trancated because there is some data in, say D1 and the text in A1 is longer then (A1+B1+C1) so it will not be displayed in full. I hope this explenation is clear. Thanks everyone. Viktor "Tom Ogilvy" wrote in message ... inexact, but the if len(Range("A1")) Range("A1").ColumnWidth then msgbox "Possiblity text is wider than column" End if Columnwidth is measured units of character width: One unit of column width is equal to the width of one character in the Normal style. For proportional fonts, the width of the character 0 (zero) is used. Regards, Tom Ogilvy "Viktor" wrote in message om... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find text in a cell and copy text to another cell | Excel Discussion (Misc queries) | |||
find text in cell and replace it with part of the text in that ce. | Excel Discussion (Misc queries) | |||
In Excel, how do I find one word in a set of text in a cell? | Excel Discussion (Misc queries) | |||
Find text within cell then display text to left | Excel Discussion (Misc queries) | |||
find number position in excel text cell | Excel Discussion (Misc queries) |