LAZ1314Copper ContributorMar 20, 2024NEED A FORMULA TO SPLIT NUMBER AFTER THE SECOND DIGIT. 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
HansVogelaarMVPMar 20, 2024LAZ1314 With such a value in A2: =--LEFT(A2,LEN(A2)-2) This can be filled down.
