Excel formula help

Highlighted
Occasional Visitor

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!

1 Reply
Highlighted

Please try

=B1 & ", " & A1

that is equivalent of

=CONCAT(B1,", ",A1)