From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Find two ways to combine these cells

Find two ways to combine these cells - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Find two ways to combine these cells

“

Beautiful. Now we have 0010 exactly. Okay. Next, put this together, YCC-J0735. And then let's do this one. DYT-E2826. Now go highlight the whole column and then go to data and Flash Fill. Oh, let's see. Oh, EYT. Good. All right, let's try this again. Flash Fill. Now looks good, let's see right here. QS-A0010. Yup, that is what we wanted. That was method one. Now let's get this out of here. Right click, delete table column, okay. Right click, get data from sheet, boost this up. Notice that our leading zeros are gone from the ID column. Here is how I'm going to handle that. Highlight it, add a column. Column from example, from selection. Go over here. Let's see. Need to see my numbers. All right. 0735. Go down here. I want 3202. Look at that, we got 001009153570. Okay. And we don't need this, right click remove. Next, highlight this column and then the Control key, highlight here, merge columns. Do I need a…

Contents