Select the cell where you want the merged result to appear.
Use this formula to merge with a space: `=A1&” “&B1`
Use this formula to merge with no separator: `=A1&B1`
Use this formula to merge with a comma and space: `=A1&”, “&B1`
Press Enter.
Copy the formula down or across as needed (drag the fill handle).
If you need to convert formulas to values: select the merged range → Copy → Paste Special → Values.