There are a couple of ways to do this. First, (as previously mentioned), you can use the CONCATENATE function, and specify the cells to include.
The second approach is to use the concatenate operator, which is the ampersand (&). For example:
Cell A1: Robert
Cell B1: A.
Cell C1: Thomas
Place the following formula into cell D1:
=A1 & " " & B1 & " " & C1
D1 will now ontain the string "Robert A. Thomas". The inclusion of " " in the formula inserts a space (or whatever you includebetween the quotes) between the values of the cells specified.
It should be noted the previous answer would actually result in a string equal to "Mr/Mrsabcxyz". If you want the cell values to be separated by a space or other character(s), you will have to include them in the CONCATENATE function as well - unless you are *certain* that the cells *always* contain a trailing space, or your intention is to have the cell contents merged with no intervening value.