Summary: This video tutorial explains how to combine two separate cells of text into one cell in Microsoft Excel. http://youtu.be/ZN6fY-f4IHg The One Minute Geek video shows you one way to combine text strings in Microsoft Excel. Read on through this post for a more detailed explanation of concatenate and an alternative to using the concatenate function. The formula that was used in the OMG video tutorial is as follows: To quickly explain what is happening here, the concatenate function in Microsoft Excel simply combines the contents of multiple cells together into one cell. The contents of those cells can be more than just text strings. Here is the definition from Microsoft. Like many things in the world of computers, there is usually more than one way to do the same task. The concatenate function is no exception. Here is another formula that will produce the same results as the formula described in the video: I know that this is an easier way to do what I explain in the video tutorial. I prefer to use functions in Microsoft Excel simply because it keeps things readable and orderly. Using concatenate as opposed to the ampersand symbol is a best practice that everyone should use in Microsoft Excel.
