![]() To do so, we need to add another argument “ ” (two double quotes around a space).ĭoing so will give us the space required between the characters. Let’s modify this formula to add a space. What we got is a long string with the concatenated values running together. CONCAT function combines the strings as we instruct it to do. You will notice that the above result is not acceptable, as there is no space in between the characters. Using the formula above, we will get the following result: You need to combine/concatenate the strings below: It is a built-in function that can be used as a worksheet function in Excel. =CONCAT (text1,text2….text_n) How to use the CONCAT Function in Excel However, you will find that both functions are available in MS Excel for backward compatibility. The function was introduced in MS Excel 2016 as a replacement to CONCATENATE function. The CONCAT Function in Excel is a text function that is used for combining text in cells. Updated JWhat is the CONCAT Function in Excel?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |