![]() =CONCATENATE(A1&A2) will give you the result as GoodMorning (where A1 has the text ‘Good’ in it and A2 has the text ‘Morning’.=CONCATENATE(“Good”,” “, “Morning”) will give you the result as Good Morning. ![]() ![]() =CONCATENATE(“Good”,”Morning”) will give you the result as GoodMorning.In its basic form, CONCATENATE function can join 2 or more characters of strings. If you’re not using Office 365, keep reading. If you’re using Excel with Office 365 subscription, I suggest you click here to skip to the part where the TEXTJOIN function is covered.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |