Posted by Chris Thompson on October 31, 2001 6:00 AM
Is there an easy way to combine the values of two columns into one column? For example if cell A1 contained "12345" and cell B1 had "6789", I need a function or macro that will make cell A1 equal "1234556789". I realize that I could simply cut and paste the data, but I am dealing with spreadsheets that have hundreds of rows that need the same function.
Thanks in advance for your response!