I want to use an Excel spreadsheet to name my nephew and find a function.

Enter the formula

=$a$2&choose(round(rand()*30,0),$b$2:$b$30)&choose(round(rand()*20 ,0),$c$2:$c$30)

Then press ctrl+shift+enter to convert to sequence, and pull down N times

This is the result you want