Stefi.
It does not work for me. Also, i dont understand your UDF(user defined
function) how to work. Would you mind to explain in details.

bpeltzer,
Using text to column function with space, it only seperates words by
words. It could not divide into two rows. Except this, is there any
ideas?

Anyway, thany you for your help.

norika


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