Thread: help from Gary''s Student
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] bplumhoff@gmail.com is offline
external usenet poster
  
Posts: 136
Default help from Gary''s Student
Hello,

I suggest to array-enter
=MultiCat(ReturnNonEmpty(IF(A1:A60,A1:A6,"")),"," )

The UDFs MultiCat and ReturnNonEmpty you can find he
http://www.sulprobil.com/html/concatenate.html

Regards,
Bernd

Reply With QuoteReply With Quote