In cell G8 and below there are numbers that need to be entered as below so if 12345 were entered it would return LPO-012345. The twist is there is a code that needs to come from each row eg. cell D8 might have "MECH" which should make cell G8 return LPO-MECH-012345. Given the number goes into the cell first is this even possible?
Code:
"LPO-"000000