Stefi,
Thank your for help. I found that the UDF can count the length of
phrase except last word. Actually, the phrase is the payee printed in
cheque. If the length is too long, it will cut into two. From your UDF,
it only cuts out the last word.
Is there any ideas to solve it if the max length of 1st row is 40, more
than that it will write in 2nd row?

TIA
norika


--
norika
------------------------------------------------------------------------
norika's Profile: http://www.excelforum.com/member.php...fo&userid=4878
View this thread: http://www.excelforum.com/showthread...hreadid=496595