Mconcat...

[How_Do_I]

Hi, can anyone see how to do this please?
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I don’t want errors or the extra commas in my return.
<o> </o>
C1 and D1 looked to be the formula that was working until I added formulas to my area of interest

Excel Workbook
	A	B	C	D	E	F
1	10		10, 21, ,			10
2	21		10, 21 , ,	#VALUE!		21
3			10, 21, , ,
Sheet1

 

[How_Do_I]

I found something Aladin had created...

This is close but not right... any ideas on this please?

Excel Workbook
	D	E	F	G	H	I
31	23		23			2310
32	10		10
33
Fixtures

 

[How_Do_I]

This is close but I just can not get what I want i.e. 23, 10...

Excel Workbook
	D	E	F	G	H	I
31	23		23			2310,
32	10		10
Fixtures

 

[Marcelo Branco]

Maybe

=SUBSTITUTE(MCONCAT(IF(F30:F35<>"",", "&F30:F35,"")),", ","",1)
Ctrl+Shift+Enter

HTH

M.

 

[How_Do_I]

Maybe

=SUBSTITUTE(MCONCAT(IF(F30:F35<>"",", "&F30:F35,"")),", ","",1)
Ctrl+Shift+Enter

HTH

M.

Beautiful Marcelo... Thanks for that... Your solution is working and in J32 below... I'd just got I32 working but your solution is much better...! Thank you.

Excel Workbook
	D	E	F	G	H	I	J
31	23		23		2
32	10		4			23, 4	23, 4
Fixtures

 

[Marcelo Branco]

Beautiful Marcelo... Thanks for that... Your solution is working and in J32 below... I'd just got I32 working but your solution is much better...! Thank you.

Glad to help

Tks for the feedback

M.

 

[Scott Huish]

Excel Workbook
	F	G	H
31	23		23, 10
32	10
33
34
35
Sheet1

 

[How_Do_I]

Excel Workbook
	F	G	H
31	23		23, 10
32	10
33
34
35
Sheet1

Hi there,

I tried your version and it didn't work... I had a second go and bingo it worked... A non-array solution... Thank you very much for that!