Paste your Bing Webmaster Tools verification code here

Blog

 

14 Feb / Combine Two Columns in Excel

person working on small business accounting and tax return

Excel Tip of the Day: Combine Two Columns in Excel

Combine two Columns in ExcelRecently 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:

 

=CONCATERNATE(A1,” “,B1)

 

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.

 

 

 

 

Tax Accounting Firms in Michigan

Return to CPA Home

Return to Tax Home

Return to Taxes Are Hard Blog

 

Trending Topics:

 

Construction helmet

Completed Contract Vs. % of Completion

Business owner in Start-up

17 Tips for your small business Start up

 

 

 

 

Follow Us

Facebooktwittergoogle_pluslinkedinyoutube
By Jschultz in Accounting, Life
Excel Tip of the Day: 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...
&p[url]=%2Fcombine-two-columns-in-excel%2F&&p[images][0]=', 'sharer', 'toolbar=0,status=0,width=620,height=280');" href="javascript: void(0)">
  • Tags > , , ,

    Post a comment