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 function, but it returns an error. I am using =CONCAT(A1," ",B1) to insert a space between the names. What am I doing wrong?
1 Reply
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
