=CHOOSE(RANDBETWEEN(1,6),"Father","Mother","Husband","Wife","Son","Daughter")=CHOOSE(RANDBETWEEN(1,5),"2500","3600","2999","4100","15000")=RANDBETWEEN(DATE(2017,12,15),DATE(2018,6,20))=RANDBETWEEN(1,5)=(A1&" "&B1&" "&C1)combine three cells (add any character between dobule quotes to include in the combined text