Basic Excel Function - How to use Concatenate and Concat Function in Excel


How to use the Concatenate Function in Excel? There are 2 methods of doing it. If you are using Excel 2013 or 2016, there is only Concatenate function. If you are using Excel 2019 or office 365 you will have both Concatenate and Concat function. Let me show you how this works.


Time Stamps:

"​​​00:00​": Intro

"​​​00:31​": How to use Concatenate Function

"01:03": Case example for Concatenate Function

"​​​01:36​": How to use Concat Function

"02:05​​​​": Case example for Concat Function

"02:55​": Convert Concatenate and Concat function into Application Programming Interface (API)


Download: AlchemyJ FREE Community Edition: https://www.alchemyj.io/download


Learn More:

How to setup AlchemyJ: https://www.youtube.com/watch?v=eTyYTf1sw9k&feature=youtu.be&ab_channel=AlchemyJ​​


How AlchemyJ works: https://www.youtube.com/watch?v=bAQHo8I1xuQ&ab_channel=AlchemyJ


Let's connect: LinkedIn: https://www.linkedin.com/company/alchemyj/

32 views0 comments