Need to return 2 digits in the last cell.

[serge]

Hi everyone,

I'm looking for a formula that will return 1 or 2 digits according to a number, not sure if it can be done ?
I have this number 4511 in PH8 and I'm separating the first 2 digits in individual cell but after the 2 digits it could be 1 or 2 digits left in that number that I would like to be separated into only 1 cell
4511 =MID(TEXT(PH8,"000"),1,1)+0 PI8= 4
4511 =MID(TEXT(PH8,"000"),2,1)+0 PJ8= 5
What formula should be use in PK8 to return 11 ? Thank you.

 

[MARK858]

Maybe...

Book2
	PH	PI	PJ	PK
8	4511			11
9	517			7
10	2910			10
11	288			8
Sheet1

Cell Formulas
Range	Formula
PK8:PK11	PK8	=--MID(PH8, 3, LEN(PH8))

]

 

[serge]

Thank you so much MARK858, it works very well, I appreciate you.