14 Feb / Combine Two Columns in Excel
Recently our firm came to the realization that accountants are close to being experts at Excel. Accountants work with this software constantly. We use it for forecasts, financial statements, ratio analysis, amortization schedule creation, and present value calculations. Just to name a few. There are so many things this program can do. It is an accountants best friend. So today we will start out with a simple trick. Today we will combine two columns on a spreadsheet.
For this tip it is best to use a simple example. So let us consider Column A to contain first names and Column B contains last names.
Step 1: In the first row of Column C enter the follow formula:
Step 2: Copy and paste this formula to the other rows in Column C.
Step 3: Highlight all the names on Column C and Click the Copy button
Step 4: Choose Edit up on the word bar at the top of the program and choose Paste Special from the menu.
Step 5: Click on the Values box then click OK
Step 6: Delete Columns A and B.