![]() 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |