Easy Excel - Combining Cells - Concatenation (10)

Welcome to the 10th Easy Excel Tutorial where I show you concatenation in Excel 2013. What you learn here can be applied to any version of Excel. Concatenation is the act of linking things, in this case, combining cell data in Excel.

More than often, you may need to combine cell data without overwriting one or the other. I show you a very easy way combine your data using a very simple method.

Chapters:
0:00 Intro
2:12 Formula
3:45 Adding a Space
4:50 Autofill
5:55 Second Example

I hope you enjoy the video and if you have any requests feel free to let me know. Thanks for watching and remember to subscribe!

#ExcelTutorial #EasyExcel

-----------

[naztronaut]

Added Chapters for everyone's viewing pleasure. I realize that I used to talk way too much in my older videos because I focused too much on the why instead of jumping to the how. If you want to skip straight to the formula, head to the second chapter starting at 2:12.

Enjoy!

[ellensquilts]

just found a video showing what you described. and it worked. so thank you again so much!

[clarissaulibarri]

I was about to go crazy, making my list. Thanks so much for your tutorial. You made it clear and very easy to navigate! :)

[mahnoorwaqar]

WOW YOU ARE AMAZING THIS IS SO EASY I HAVE 150 STUDENTS I NEEDED TO MERGE NAMES FOR!! THANKYOUUU

[pushpaverma]

Thank you for sharing this code. it will help me doing my job faster.Appreciated. Thanks again.

[pratikshab]

Thank u, u save my time, i have do 6345 entries, i typed it till 3k ..And I watch ur vdo, and u save time

[lydiathemalignant]

Holy moly, thanks a lot! It's like magic.

[amoltofi]

Easier than others, good information provided you

[planetnephtune]

that was great!!! was really amazed!!!

[shuaibusaminu]

This is quite helpful, keep it up Sir.

[JGale]

Thank you so much, this will definitely help me with saving time! Good job!

[MauiRealEstateVideoTours]

Bro.... 2:00 in and you still haven't gotten to the point. OmG

[ellensquilts]

hello again. I saw a similar question and your solution for deleting the reference columns after concatenation but after trying it, the columns still were either duplicated or deleted. is there a video explanation of how to do it? thanks in advance. you are really great.

[beckydrake]

Thank you! This was very helpful. Can I remove the original cells now that I have combined into one?

[dilipdabade]

Thanks a lot for updating this...it help me savibg lot of time..but one query what if i want to combine from three cells and want to put comma to seprate

[ellensquilts]

THAT WAS so helpful. but this is my problem: after I combine the first name (column A) and last name (column B) into the full name (column C), when i try to delete the first two columns (A & B ) column C gets deleted. what am i missing! thanks in advance for answering.

[christinadestephano]

The drop down arrow keep copying tje first concatenation and not the later cells

[mandycollins]

My friend, you just saved me HOURS of work. Thank you!!