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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks