From the course: Excel Formulas and Functions Quick Tips
Join text with an ampersand - Microsoft Excel Tutorial
From the course: Excel Formulas and Functions Quick Tips
Join text with an ampersand
- [Instructor] Some tasks can be performed without needing a function. Let's join the contents of these two cells together using an ampersand. After putting in my equal sign, I'll type in my first cell. Now we need our ampersand to join the contents of the second cell, but before that, we need a space in between the two names to add literal text, and close it in quotation marks. In this case, a single space. I'll join that text with another ampersand, and now I can put in the remaining cells. Hit the enter key and the formula is complete. Excel even autofill the contents of this for me. If it didn't do that for you, you can select the cells, and from the home ribbon tab, select fill and then down. A common question is when to use the ampersand, and when to use the full word AND, use an ampersand when you're joining text strings together. Use AND as an operator to perform logic tests. We're going to be doing that in later videos.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.