Method 5: Automatically merge workbooks The fifth way is probably most convenient: Click on “Merge Files” on theProfessor Excelribbon. Now select all the files and worksheets you want to merge and start with “OK”. This procedure works well also for many files at the same time and is ...
This can be done with flashfill. Enter manually "Mr. Smith", "Mr. Jones" in cells C1:C2 and then press ctrl+E. This returns the result shown in attached file. =CONCATENATE(A1&" "&B1) This works as well if you copy the results of the formula and then paste only v...