Answer:
with space: =A2&" "&B2
without space: =CONCATENATE(A2,B2)
Explanation:
When using Microsoft Excel the function that you would want to use would be the following
=A2&" "&B2
In this function, you will be combining the text in cell A2 and B2 with a space in the middle, you can change to the cells that you want and simply add &" "& in between them to combine them with a space.
If you simply want to combine the words with no space in between them you can use the concantenate function which combines words in two cells into one but without space.
=CONCATENATE(A2,B2)
