How to use the CONCAT function in Excel (vs the CONCATENATE function)

u are very moza

Thank's a lot

That is so greating video.

THANK YOU! I was browsing for other methods because the =concatenate(transpose method didn't work as my F9 key wouldn't work. This is so much eaier

Thank you very very much :)

Very well explained, can you make more videos of other Microsoft office products.

What if I want to leave a space in between?

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.

Great being able to specify a range. Frustrating how this never was originally in Excel given it is such an intuitive notion.

Perfect. Thanks.

Many thanks for explanation