This does not affect the data in column C when using Excel's capability to automatically combine text. To combine first and last names in cells A1 and B1 using functions, enter the following ...