This function is similar to CONCAT but more powerful. In the above examples, we have used CONCAT in different ways to combine values from a range. This function does not provide the delimiter argument so you need to define the spacing in the formula. Note: If text 1 is a range then text 2 is not mandatory. text2 may or may not be required depending upon the nature of text 1.text1 can be a range, string or a reference cell to combine.There is no need to select each and every cell you want to join. You can combine a string by just specifying the range and your work is done. This function allows you to combine text, strings or range into one string saving time and energy. If you have been doing this using CONCATENATE in each and every cell, you need to stop and learn more about CONCAT. Let’s say you need to combine A1:A50 to B1:B50. How do you deal with the data when you have to combine a long list of cells to another list? This function is an improvement over CONCATENATE. Today in this post, I’d love to share those “ 6 New Excel Functions Introduced in Excel 2019/365“. One thing which I love the most about Microsoft TEAM that they keep on introducing new functions from time to time.įor Example: In the latest version of Excel i.e 2019/Office 365, they have introduced 6 New functions which can change the way you deal with the data. You must have heard a number of times that the power of Excel lies in its inbuilt functions and flexibility to create formulas as per your need and requirement. Microsoft Excel is a Powerful Tool, Period.Īnd once you are loaded with all the basics of Microsoft Excel, it’s important for you to master the functions.
0 kommentar(er)
