Gabriel,

Formula wise (assuming that your values are in A, B & C).
In D1, enter the following:
=IF(A1=0,1,A1)&"_"&IF(B1=0,1,B1)&"_"&IF(C1=0,1,C1)
and copy down

John

"Gabriel" wrote in message
om...
Hi,

I have the following table (in reality it is quite large) in an excel
wksheet:

1 1 1
2
2 1
2
2 1
2 1
2
3

I want to write a procedure such as I could obtain in another wksheet
the following result:

1_1_1
1_1_2
1_2_1
1_2_2 and so forth. There is a pattern here. Is there is a way to set
up a procedure to take advantage of this pattern? Does anyone has a
hint?

Thank you in advance
Gabriel