On May 8, 11:15 am, Harlan Grove wrote:
Nikki wrote:

...I tried the UDF to no avail.

String of other values: W43 = 1.2, 5.6
Array: W25:W41 = 0.5, 0.625, 1, 2, 3.75, 4, 6, 7, 7.5, 8, 9 -- in
addition to 6 blank cells
Returned string: AA32 = "0.51.2, 5.60.6251.2, 5.611.2, 5.621.2,
5.63.751.2, 5.641.2, 5.661.2, 5.671.2, 5.67.51.2, 5.681.2, 5.69"
Wanted returned string: "0.5, 0.625, 1, 1.2, 2, 3.75, 4, 5.6, 6, 7,
7.5, 8, 9"

...

I had tested the udf. For me, the formula

=foo(", ",W25:W41,W43)

returns

0.5, 0.625, 1, 1.2, 2, 3.75, 4, 5.6, 6, 7, 7.5, 8, 9

What version of Excel are you using?

It works, user error... I was using the wrong syntax.

I will go with this UDF since the add-in requires additional
installs.

Thank you very much!