You can also insert a number obtained from a formula in-between textual content.įor example, you may have your customers’ first names in column B, and their last names in column C. In Excel, such content is called text strings. For example, you can use this method to combine pieces of textual content from different cells. If you choose to concatenate cells instead, you won’t merge the cells themselves but combine their content.Ĭoncatenation doesn’t impact cells but joins multiple values. As a result, you get a single large cell that is displayed across multiple columns or rows. The first option means turning multiple cells into one. Generally, Excel enables you to combine data in two ways: you can either merge cells or concatenate their values. In this guide, we will look at concatenation in detail and examine the techniques that you can use in different situations. Most often, you use concatenation in Excel to join such data as names and addresses, display time, and date. The second process is called concatenation. You may also need to do the opposite, combining data from multiple columns into one. Sometimes, you may need to split the content of one cell into different cells. When dealing with Excel workbooks, data may be structured in a way that doesn’t fit your needs and objectives.
