If you can limit yourself to 254 names
and want an easy way without VBA, then go to
Tools Options Custom Lists Import list from cells, and enter
$A$1:$A$254
Enter the name at A1 into C1 and select it and 20 blank cells
below it. Drag the fill handle down to row 5334.