Forum Discussion
Joining 2 cells together in Excel
I am trying to effectively merge two columns, each containing names (column A has surname, column B has forename, I want in the same column). I have followed the "HELP" instructions, using the CONCAT ...
Hi,
My guess that the error type is #NAME?
If so, you have to have Excel 2019 or Office 365 to use this function.
If you have an earlier version of Excel, you can use other options as follows:
=A1&" "&B1
=CONCATENATE(A1," ",B1)
Hope that helps