Forum Discussion

retonoo's avatar
retonoo
Copper Contributor
Jan 14, 2020

Poner un telefono en varias columnas

Quisiera poder dividir un numero telefónico en varias columnas.

ejemplo 98765876 que quede en 9  8  7  6  5  8  7  6

1 Reply

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    retonoo 

    Perhaps the attached example is a solution you can work with in two different ways. The first with help of the MID(....) function. The other using the SEQUENCE function. The latter may not be available on your Excel version though.

Resources