Merging name fields into one column
I have an excel file that has the following columns
First Name, Middle Name, last name, Suffix
col 1 col 2 col 3 col4
first Middle Last suffix
Neil Avery Stagner. Jr
I want the outcome to be all in one column that reads
Col 1
first middle last suffix
i.e. (Neil AveryStagner, Jr)
can you tell me how to do this...and the formula!
Thank you!