If you have a spreadsheet that contains a column of first names and a column of last names, and you would like to combine those names into one column, here's a quick trick that will get the job done.
For this example, let's assume that Column A contains first names and Column B contains last names. We will place the combined first and last names in Column C, with a space separating the first and last names.
Step 1: To combine two columns of names into one column, use this formula in the first row of column C:
About David Ringstrom, CPA
David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. His mantra is “Either you work Excel, or it works you.” David offers spreadsheet and database consulting services nationwide.