Home

Joining 2 cells together in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-856239%22%20slang%3D%22en-US%22%3EJoining%202%20cells%20together%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-856239%22%20slang%3D%22en-US%22%3EI%20am%20trying%20to%20effectively%20merge%20two%20columns%2C%20each%20containing%20names%20(column%20A%20has%20surname%2C%20column%20B%20has%20forename%2C%20I%20want%20in%20the%20same%20column).%20I%20have%20followed%20the%20%22HELP%22%20instructions%2C%20using%20the%20CONCAT%20function%2C%20but%20it%20returns%20an%20error.%20I%20am%20using%20%3DCONCAT(A1%2C%22%20%22%2CB1)%20to%20insert%20a%20space%20between%20the%20names.%20What%20am%20I%20doing%20wrong%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-856239%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-856254%22%20slang%3D%22en-US%22%3ERe%3A%20Joining%202%20cells%20together%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-856254%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F409207%22%20target%3D%22_blank%22%3E%40Mrs_Burch%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20guess%20that%20the%20error%20type%20is%20%3CSTRONG%3E%23NAME%3C%2FSTRONG%3E%3F%3C%2FP%3E%3CP%3EIf%20so%2C%20you%20have%20to%20have%20Excel%202019%20or%20Office%20365%20to%20use%20this%20function.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20have%20an%20earlier%20version%20of%20Excel%2C%20you%20can%20use%20other%20options%20as%20follows%3A%3C%2FP%3E%3CPRE%3E%3DA1%26amp%3B%22%20%22%26amp%3BB1%3C%2FPRE%3E%3CPRE%3E%3DCONCATENATE(A1%2C%22%20%22%2CB1)%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3C%2FLINGO-BODY%3E
Mrs_Burch
Occasional Visitor
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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies