Use the CONCAT function: `=CONCAT(A1,B1)`
Use the TEXTJOIN function: `=TEXTJOIN(” “,TRUE,A1:B1)`
Use the ampersand operator: `=A1&B1`
Add a separator with ampersand: `=A1&” “&B1`
Fill the formula down for all rows
Copy the results and paste as values if needed
Use Flash Fill by typing the combined pattern and pressing Ctrl+E
Use Power Query to merge columns for larger datasets
Use CONCATENATE in older Excel versions: `=CONCATENATE(A1,B1)`