Concatenate Function in Microsoft Excel 

Short and simple. Great explanation and examples. Thanks!

Exactly what i was looking for. Thanks TrainSignal

Very clean presentation and it helps me to understand it in a few seconds. thank you....

That was a great help and very clearly explained! Many thanks!

Thank you! Very helpful and so clear!

Excell is so powerful. I like this video on using Microsoft excel to combine 2 cells.

Excellent. Thank you!

It was useful however one easy way could be =concatenate(text1," ", text2). That will complete your full name with a space in between.

Very informative, thank you ❤️

Thank you that was very helpful

Very Helpful man thanks a lot

Thank you soo much.... It helped me alot..

AWESOME!! THANK YOU SO MUCH...

Thank you for making this video :)

Thankew Its very helpful

So much easier than how my teacher was trying to explain it. Thank you for making this understandable.

Thank you so much :)

Thank you for your simple and nice explanation .... But I have a problem in using the "Concatinate" function in making a invigilators' duty roster .... When I drag the names from a column under "Concatinate" , it gives only the first name ...... "Concatinate" require commas "," by manually between the names ... Which seem uncomfortable for joining more names ....... So if you any solution , please share with me ....

does this work when you have numbers and text and you want to insert into a table in sql with data types

Amazing. Thank you

Ben Affleck teaching excel formulaes , thank you!!

thanx a lot

Lovely, thank you

where i can download the 'vv' lisp file?

Thanking you soooo much..

Thank you

Thank you🙂

Thanks dude :)

thank u a lot

thankss!

Thanks Sir

Thanks!

thanks a ton

Thank you so much :))

hello sir i am facing some problem while saving my document i.e " xls may contain features that are not compatible with web page. do yo want to keep the workbook in this format " please let me know how to resolve this issue.. hope you will to it..

thankyou

I want to include dash "-" in-between those numbers, any idea how?

Can I prepare a third concatenated column where I want the data to go into before I have put the data there

can you concat a single cell and a column?

Thanks🙏❤❤

thanx

thanks

This has been very helpful, but it was missing one vital step for me, once I finish concatenate, I want to delete the source columns, and since the formula is still there I can't just delete the columns. What I do is copy the new concatenate column and then in a new column I "Paste Special" and choose to paste the column as a value. This one I can delete the source columns.

how to bold words in concatenate format?

I can just simply use this "&". Same value would come out. Ex. =B2&", "&A2. I have been using it since 2007.

What is the shortcut of doing it without dragging?

Can you also explain how to add dates

It is partially working, I need result as ordinary text to copy&paste to any other doc.

Video is not streaming

E.g. Percentage - 35% & Admin Rights When i used concantenate formula for combine of above But it show 0.35 Admin Rights But i need same 35% Admin Rights How its solve & i need your help

Thank you So much Sir

thank you!

This just saved my ass lol

sir excel emadressa ki 11 video upload kar do

LL

That was a great help and very clearly explained! Many thanks!

Thank you