Formula Breakdown: ➥ LEFT(B5,3) The LEFT function will keep the first three digits of the number in Cell B5. It will return: “675” ➥ MID(B5,5,2) Then the MID function will keep the two digits starting from the 5th digit of the number in Cell B5. The output is: “48” ...