>Does anyone knows how i can determine length of some text written
>in
TTF.
Idea is to determine how much text can fit in one cell.
For example
>A1 contains text "Some text is too long!" in TTF.
And cell A1 can handle only
>"Some text is" , text "too long" is hidden
under cell B1.
Now, i need some
>way to separate these two parts in two cells A1 & A2.
Standard LEN function
>can't help, because it returns number of
characters
which do NOT occupy the
>same space in TTF(True Type Font).

  You could copy the cell's.value to another cell on a work sheet and run the
work  cell's AutoFit method. Next you can get the work cells width. Let me know
if you have questions. Good luck... Russ