ExcelBanter - help from Gary''s Student

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - help from Gary''s Student (https://www.excelbanter.com/excel-programming/380667-re-help-garys-student.html)

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

All times are GMT +1. The time now is 02:15 AM.