Formula in D4 : =MID(C4,43,5) Formula in D5 : =MID(C5,43,5) Formula in E4 : =RIGHT(C4,29) Formula in E5 : =RIGHT(C5,29)