Can Pls modify the function so that the result would appear on separat
cells instead of being separated by commas

Something like this

1111 abc xyz
1234 qw

--
sp12
-----------------------------------------------------------------------
sp123's Profile: http://www.excelforum.com/member.php...fo&userid=3116
View this thread: http://www.excelforum.com/showthread.php?threadid=52194