Hi Bebo - If i understand you correctly, I am not looking to generate a specific random number but any random number within the CONCATENATE output that does not update whenever the workbook recalculates.

Sorry if I may not have been clear, the current formula output result is = Student davids-steve-222088
However, when excel recalculates automatically, it will change the Student davids-steve-222088 to something random again. This is what I am trying to hope get asisstance on, to stop this from happening if at all possible.