Produce Combinations

[Cobber2008]

I have a table with 4 columns with number in them. i want to be able to produce all the various combinations as per what i started in the combination column. Any idea how to do this thank you.

A	B	C	D		Combinations
1	5	1	5		1-5-1-5
2	3	9	3		1-3-1-5
12	13	3	6		1-13-1-5
4	2	11	9		1-2-1-5
15	7	12	1		.
6	1	5	2		.
					.
					6-1-5-2

 

[felixstraube]

Nice!!! I really like your solution with the MID/BASE functions, so cool! (hope this isn't seen as spam).