Excel, qn regarding generating random marital status

Question

i have a qn regarding excel, does anyone here know how to randomly generate a character between "M","S" and "D" for each cell? Thanks you so much in advance

question from:https://stackoverflow.com/questions/65679932/excel-qn-regarding-generating-random-marital-status

Answer 1

Try below formula-

=INDEX({"M","S","D"},,RANDBETWEEN(1,3))