Combining two excel cells with one of the numbers having a hyphen

%3CLINGO-SUB%20id%3D%22lingo-sub-2600067%22%20slang%3D%22en-US%22%3ECombining%20two%20excel%20cells%20with%20one%20of%20the%20numbers%20having%20a%20hyphen%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2600067%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20combine%20two%20columns%20of%20number%20in%20Microsoft%20Excel.%26nbsp%3B%20I%20have%20been%20able%20to%20combine%20the%20two%20cells%20if%20I%20remove%20the%20hyphen%20in%20the%20second%20cell.%26nbsp%3B%20But%20I%20have%20many%20Rows%20of%20columns%20that%20I%20need%20to%20combine.%26nbsp%3B%20Do%20you%20know%20a%20way%20I%20can%20combine%20these%20two%20into%20one%20column%20as%2072381510036-8.%3C%2FP%3E%3CP%3EI%20have%20tried%20doing%20this%20with%20%3Dconcatenate(A1%2Cb1).%26nbsp%3B%20But%20creates%20an%20error%20I%20assume%20because%20of%20the%20hyphen.%26nbsp%3B%20Thanks!!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20border%3D%220%22%20width%3D%22147px%22%20cellspacing%3D%220%22%20cellpadding%3D%220%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2263.725px%22%20height%3D%2219%22%3E723815%3C%2FTD%3E%3CTD%20width%3D%2263.275px%22%3E10036-8%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2600067%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2600237%22%20slang%3D%22en-US%22%3ERe%3A%20Combining%20two%20excel%20cells%20with%20one%20of%20the%20numbers%20having%20a%20hyphen%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2600237%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1118736%22%20target%3D%22_blank%22%3E%40matthewMurph2777%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20appears%20to%20work%20for%20me%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S0645.png%22%20style%3D%22width%3A%20415px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F299993iF38F65EB21492147%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22S0645.png%22%20alt%3D%22S0645.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2602471%22%20slang%3D%22en-US%22%3ERe%3A%20Combining%20two%20excel%20cells%20with%20one%20of%20the%20numbers%20having%20a%20hyphen%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2602471%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20you%20can%20use%20any%20of%20the%20three%20methods%20shown%20in%20the%20image%20below%26nbsp%3Bif%20concatenate%20does%20not%20work.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1118736%22%20target%3D%22_blank%22%3E%40matthewMurph2777%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I am trying to combine two columns of number in Microsoft Excel.  I have been able to combine the two cells if I remove the hyphen in the second cell.  But I have many Rows of columns that I need to combine.  Do you know a way I can combine these two into one column as 72381510036-8.

I have tried doing this with =concatenate(A1,b1).  But creates an error I assume because of the hyphen.  Thanks!!!

 

72381510036-8
3 Replies

Hi, you can use any of the three methods shown in the image below if concatenate does not work. @matthewMurph2777 

@nidhiachhaa9 

If so we may add

=TEXTJOIN("",1,A1,B1)

for the collection. Taking into account it works, as CONCAT(), not on any Excel on any platform.