

Monthly Archives: December 2005

Home >>
Blog >>
Archive: December, 2005

How to stack columns of data into one column in Excel

Problem In Excel, from time-to-time you may want to stack different columns of data into one column. For example, if cell A1 has the value of Bob, A2 has Jane, and B1 has Mary and B2 has Sue, you may want to collapse all the values from both A and B columns into one column. […]

2 Convert a number to its equivalent letter

If you want to convert a number to its equivalent letter, for e.g. 5 to E, you can use two approaches. 1. Insert this code in a Module and use this function ‘Author: Alan L. Lesmerises‘From: http://www.freevbcode.com/ShowCode.asp?ID=4303 Function ColumnLetter(ColumnNumber As Integer) As String If ColumnNumber > 26 Then ‘ 1st character: Subtract 1 to map the characters […]