MICROSOFT EXCEL CONCAT VS. CONCATENATE FUNCTIONS (Office 365 and older versions)

Microsoft Excel concat and concatenate functions are very similar functions to each other, but the concat function is the newer version of concatenate. This video will cover how and when to use the concat function and how better it is than the concatenate function.
Other Excel videos:

[darkhippie]

You helped me figure out what I was missing! I had everything except the wrap text! Thank you!!

[lanorryder]

You're Heaven Sent!! Thank you for making this easy :)

[maddinenisrilatha]

Thank you my doubts about Concat got cleared with this video

[MsDancingmoon]

This was the best explanation, you saved me so much time and frustration!!

[vijayaraghavankrishnaswamy]

Simple and clearly described method.thanks

[nzkiwi]

Very well explained and demonstrated, thanks a lot.

[garciarogerio]

I was asked about it in my job interview 😅😂🤣. Thank you. It’s well noted now

[ZeeStreamYT]

Thank you for your video. I'm using Excel of Office 365, but function 'CONCAT' is not available & only available is 'CONCATENATE'? Any solution for this?

[johnflynn]

Thanks for the video. I've got a problem. How do I save a column that I've created with CONCAT so that it doesn't depend on the source columns? I copy and paste my "newly created" column into a new column, but if I try to delete the source column I lose everything ! Other videos suggest that the "copy and pasted" version will be independent data - I must be doing something wrong.

[efemzyekun]

Thanks a bunch for this tutorial. However, I tried this method on a set of numbers, where i needed to add a country code in front of multiple MSISDN's of customers and it only concatenated the first number, such that I had to manually do same for each number in every cell. Is there a way I can apply this method once and the country code would automatically populate in every number in the cell rows below?

[teaganspettigue]

Thank you for the video! How about a large document where some cells are empty, is there a way to ignore them without extra spacing or commas?

[jonelatendido]

How to join 2 cells without losing the format, the other one cells is Bold, while the other one is italic? Is there a way not to lose the formating?

[martins]

I feel Microsoft missed a trick here. This just doesn't cut it in the "Real World".

If you compare this to say, the XLOOKUP function, that really did fix a number of defects in existing lookup functions, it's quite lacking and rapidly becomes a hugely fiddly task.

If I was designing this, I would want to be able to select A1:E1, H1, K1, M1:P1

AND have an argument to select a delimiter across all (e.g. ", ")

Whilst CONCAT is a minor improvement, it still misses this fundamental which would fix the limitations properly.

[JJ_TheGreat]

Why not just use the "&" symbol? It is shorter than both of them!