Excel Training - Easy - Intermediate & Advanced Excel Tips & Tricks - Vol #2
Updated: Jan 26
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 AllExcel MVP Bob Umlas shows a variety of advanced tips and tricks.
October 29, 2022 Easy How to format text within a cell: #1 Cell A1 shows text that we formatted. We will show you how to format the text in cell A3. #2 Here we selected cell A3 to make it the active c
Bob Umlas biography