Hui Excel Ninja Staff member Aug 6, 2010 #2 If they are numbers in C1: =A1+B1 If they are text in C1: =A1&B1 and copy down Adjust Columns to suit If you don't want the original 2 columns, copy the New Column and paste as values over the top of itself, then delete the old columns
If they are numbers in C1: =A1+B1 If they are text in C1: =A1&B1 and copy down Adjust Columns to suit If you don't want the original 2 columns, copy the New Column and paste as values over the top of itself, then delete the old columns