How can I merge two columns of text into a single column?
This could come up when you have to move data from one data source to another, where the data was stored as 'first name' in one column and 'last name' in a separate column. You want to move the information to a single column of data.
In our example, First name is in col A, Last name is in col B.
The new column for Full Name will need a function, that uses the text function 'concatenate'.
The function for Full Name will need to be either:
=CONCATENATE(A1&" "&B1) or
Paste either of these functions all the way down the column for Full Name and you will be good to go.