top of page

Excel Training - Easy - Intermediate & Advanced Excel Tips & Tricks - Vol #2

Updated: 5 days ago

December 1, 2022

Easy Trick

You have data in different columns, and you want to combine them into a new column. In the example below, we have data in columns A, B, C & D. We need to combine those columns to give us a new column with that data.

We are going to write a formula that will do this for us. The formula bar displays this formula. It tells Excel that we want to combine A1 - then 2 spaces - then B1 - then a space - then 3 dots - then another space - then C1 - then a space hyphen space - and finally D1. The result of the formula is the contents of E1.

The next step is to fill down.

And last, copy and paste special (values) so Column F is only data (no formulas)

Here's a video on the same topic.

Intermediate - Stay tuned

Advanced - Stay tuned

Find out why Bob Umlas is the Excel Legend

Recent Posts

See All

We created Inventory Magic Spreadsheet to be an superior solution for inventory control. We based it on Excel so people could leverage the skills they already knew. Instead of the Kitchen Sink approac

bottom of page