Forum Discussion

Pete_Atkinson's avatar
Pete_Atkinson
Copper Contributor
Sep 30, 2020
Solved

Displaying individual digits from a serial number

I have to create a spreadsheet to create serial numbers then break the serial number down to it's individual digits. I might not be explaining this that well so an example of what i need to achieve i...
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Sep 30, 2020

    Pete_Atkinson 

    In B2:

     

    =MID($A2,COLUMN()-1,1)

     

    Fill to the right as far as you want, then fill down.

HansVogelaar's avatar
HansVogelaar
MVP
Sep 30, 2020

Pete_Atkinson 

In B2:

 

=MID($A2,COLUMN()-1,1)

 

Fill to the right as far as you want, then fill down.

Pete_Atkinson's avatar
Pete_Atkinson
Copper Contributor
Sep 30, 2020

HansVogelaar  Thank you so much for that.

 

If it isn't too much trouble would you mind explaining the formula so i know how it's working?