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 ...
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.