Try the following formula:

=CHAR(RANDBETWEEN(32,126))

which generates a random char whose ascii code is between 32 and 126.
Please note that 32 corresponding to space.


--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download

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