There are also functions that work on text. Let’s try the CONCATENATE function.
Click into cell C5 and type this formula:
=CONCATENATE(A5, ” “, B5)
Then hit Enter.
You’ll see the message “Welcome to Spreadsheeto” in the cell.
How did this happen? CONCATENATE takes cells with text in them and puts them together.
We put the contents of A5 and B5 together. But because we also needed a space between “to” and “Spreadsheeto,” we included a third argument: the space between two quotes.
Excel has dozens of useful functions. To find the function that will solve a particular problem, head to the Formulas tab and click on one of the icons:
Scroll through the list of available functions, and select the one you want (you may have to look around for a while).
Then Excel will help you get the right numbers in the right places:
If you start typing a formula, starting with the equals sign, Excel will help you by showing you some possible functions that you might be looking for:
And finally, once you’ve typed the name of a formula and the opening parenthesis, Excel will tell you which arguments need to go where:
If you’ve never used a function before, it might be difficult to interpret Excel’s reminders. But once you get more experience, it’ll become clear.