Ayudan

Copper Contributor
Hola a todos necesito que me ilustren . Quiero programa una casilla de Exel para colocar un número "X" , y tal número "X" va hacer el límite dd una secuencia de número
Es decir
X= 14 entonces 1.2.3.4.5.6.7.8.9.10.11.12.13.14
X = 4 entonces 1.2.3.4

El número que varíe es x y este será la veces que generará
1 Reply
If you have office 365, then I think you could use the textjoin and sequence functions (I don't have sequence, but I think this would be how it would look if A1=14):
=textjoin(".",,sequence(A1))

Otherwise, I know this will work if you at least have textjoin (office 2016):
=textjoin(".",,row(indirect("1:"&A1)))

And, if you don't have textjoin, then I'm not sure you can do it with native excel functions and would have to resort to a vba user defined function.