Use this formula
http://www.tushar-mehta.com/excel/ti..._alphanum.html
...8 times (8 rows) and then concatenate all the rows to one
Alphanumeric string.
=A1&A2&A3&A4&A5&A6&A7&A8

HTH
Ola Sandström


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=385434