Joining 2 cells together in Excel

Copper Contributor
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

@Mrs_Burch

 

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