NEED A FORMULA TO SPLIT NUMBER AFTER THE SECOND DIGIT.

[LAZ1314]

SO IF THE NUMBER IS 2209..I NEED 22, IF THE NUMBER IS 15988..NEED THE 159, IF THE NUMBER IS 188..I NEED THE 1

[#2]

@LAZ1314 

With such a value in A2:

=--LEFT(A2,LEN(A2)-2)

This can be filled down.

[#3]

=INT(A1/100)

@LAZ1314 

[#4]

Thank you so much. it works perfectly

[#5]

This works thanks