I have three columns:
First Name, Middle Name, Last Name

Whether or not a given row contains information in each column is somewhat random. Sometimes it might be all three names in the "Last Name" column. Sometimes it might be a business name such as "A Gathering Grove Book Store" all crammed in the first name field. Sometimes it will be a blank last name and only a first and middle name. Somtimes it might be a first name with a blank middle and last name. Etc.

I want to concatenate all three columns together into a single new column called "Name" (obviously with the result containing a space between each of the three values so that you don't get a result of "TonyFabris").

When I try to select the three columns and press the MERGE CELLS button it does not do as I hope it would do. It gives me a complaint box and then makes all the data in the columns disappear.

How do I do this in Excel without hand-editing hundreds of rows of data?