Suppose column D stores surnames (for example, 10): Zhang, Wang, Li...
Column E stores common characters for the first character of names (for example, 10): success, fame, profit, beauty....
Column F stores the commonly used characters for the last character of the name (for example, 10): success, fame, profit, beauty....
Enter in A1
=INDIRECT("D"amp;INT(RAND()*10))
Enter in B1
=INDIRECT("E"amp;INT(RAND()*10))
Enter in C1
=INDIRECT("F"amp;INT(RAND()*10) )
Select A1, B1, C1, drag down and copy the formula to the third row.
Note: For convenience, only 10 surnames and 10 common names are entered, so the multiplier in the formula is 10, which can be adjusted according to the amount of data.