Forum Discussion
Combining two excel cells with one of the numbers having a hyphen
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!!!
| 723815 | 10036-8 |
3 Replies
Hi, you can use any of the three methods shown in the image below if concatenate does not work. matthewMurph2777
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.
