A | B | C | D | E | |
1 | Item 1 | Item 2 | Function | Result | |
2 | Method 1 | Hello | World! | =CONCATENATE(B2,C2) | Hello World |
3 | Method 2 | This is a way to | Concatenate | =B3 & C3 | This is a way to Concatenate |
Alternatively, you can simply use the & symbol to join the contents of two cells.