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