Home

Excel formula help

365msacct
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

Please try

=B1 & ", " & A1

that is equivalent of

=CONCAT(B1,", ",A1)
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies