Forum Discussion
Excel formula help
Hello, I need an Excel formula to combine 2 cells without loosing data (last name,first name). I tried the =CONCAT(B1,A1) and the answer is showing the last name and first name together with no comm...
Please try
=B1 & ", " & A1
that is equivalent of
=CONCAT(B1,", ",A1)