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 comma (eg.: DoeJohn - I need: Doe,John) - so when I try to add a comma to the formula, it doesn't work either: =CONCAT(B1,","A1) or =CONCAT(B1,&","A1) etc... Please help!
Please try
=B1 & ", " & A1
that is equivalent of
=CONCAT(B1,", ",A1)
