Re: Splitting A Number Into Segments
I like your lookup option.
Nice and short - sweet.
I'd done this a bit longer once again, so i liked your solution.
I suppose that triste will have to change the reference from A2 to A1 in your formula in F2 unless s/he had a typo.
so I need that uumber in cell (a1) to be extracted acoording to that role and give me the final result