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

Copper Contributor

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.