Combine first and last names - Microsoft Support
https://support.microsoft.com/en-us/office/combine-first-and-last-names-6a2c1222-837d-482e-94f0-a38a4effb1b5
WebTo combine first and last names, use the CONCATENATE function or the ampersand (&) operator. Important: In Excel 2016, Excel Mobile, and Excel for the web, this function has been replaced with the CONCAT function. Although the CONCATENATE function is still available for backward compatibility, you should consider using CONCAT from now on.
DA: 91 PA: 65 MOZ Rank: 98