There are 2 ways to combine text from different cells together:
1) Use the concatenate function
2) Use "&" -> yes just "&"
Let me show you an example:
I want to combine the following text into 1 cell
 |
| Combining text from different cells together |
Using Method 1:
- You just need to type in cell A3's formula bar: =CONCATENATE(A2,B2,C2,D2,E2,F2,G2)
Using Method 2:
- You just need to type in cell A4's formula bar: =A2&B2&C2&D2&E2&F2&G2
We're done and it will look something like this!
 |
| Combining text from different cells together |
And if you need to add spaces in between when you combine the text, all you have to do is to just add &" ", remember to put a space between the "".
Same goes for adding text, just put the text in between "".
Below is an example of how you can do it:
 |
| Combining own text to cells |
