Quote:
|
Originally Posted by Sparky12
Hi
I need to break this data up into separate cells to run my calculations eg: last four starts would have 1 1 2 1 in four separate cells - but am unclear whether Excel has the funtionality to allow me achieve this?
Has anyone any experience or advice they can provide?
Thanks everyone
|
Assume the number 1221 is in cell A1
In cell B1, express the number 1221 as text. =TEXT(A1,"#")
In cell C1, select the first character of the text string "1221". =MID(B1, 1, 1)
In cell D1, select the second character of the text string "1221". =MID(B1, 2, 1)
In cell E1, select the third character of the text string "1221". =MID(B1, 3, 1)
In cell F1, select the fourth character of the text string "1221". =MID(B1, 4, 1)
Hth. Let me know if you need a clearer explanation.
Best
Chris