Put all the possible characters in a cell, and name it as "list".
Then
=MID(list,1+INT(RAND()*LEN(list)),1)
will give a random character from the list. Use as many of these
as you need.

Andrew

Tayo wrote:
How can I generate random characters (both letters and numbers) into
different cells (both rows & columns) at he same time in excel?