![]() ![]() Open an existing workbook containing data you wish to join together or create a simple new workbook with data such as shown below. ![]() To use the Concatenate function, follow these steps: Remember, the term it dynamic means it will refresh itself if your original information changes. There are other ways to perform this in Excel however the biggest advantage to Concatenate is that it is dynamic. The Concatenate function is going to allow us to join information from multiple cells into one single string of text. ![]() =CONCATENATE(text1,text2,…) How to use Concatenate This refers to the way in which the function is formatted – in other words, where you need to place a bracket or a comma. Concatenate SyntaxĪll functions in Excel have a syntax. If you are entirely new to using functions in Excel then be sure to check out my post on Formula Basics in Excel. The meaning of the word concatenate is to join things together, and that is exactly what concatenate in Excel will do for you. The term “dynamically” means that if any data in the original location changes, our Concatenate function will also pull that new information into our cells, therefore, creating dynamic content. For this example, the Concatenate function in Excel works perfectly as it allows you to join strings of information together dynamically. This week I had a request to show how to join text together from different columns in Excel. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |