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!
