Excel Training - Easy - Intermediate & Advanced Excel Tips & Tricks - Vol #2
Updated: 5 days ago
December 1, 2022
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