Need to use find and replace to change 1 digit in a 6 digit...
NewFstuses theCHOOSEfunction to pick, based on the value ofidx, the text "2" or "3" etc. in sequence The final formula concatenates the two text stringsNewFstandNewLastto give your new six digit number. I've at