Aug 02 2021 01:50 PM
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 |
Aug 02 2021 02:06 PM
Aug 02 2021 11:56 PM
Hi, you can use any of the three methods shown in the image below if concatenate does not work. @matthewMurph2777
Aug 03 2021 09:14 AM
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.