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 AllThis is an advanced 2 hour Excel training with Excel MVP Bob Umlas (AKA Excel Legend) Submit questions to: Excel.Legend@rwsinfo.com TY
Having gone through multiple State Wage & Hour Audits, we knew there had to be a better way to record time. In addition, we thought about all the other times when we had to calculate time. Projects. C
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