I have a Google spreadsheet set up for work with a long list of names, phone numbers, and other data, with each data item in its own column. When I received the original sheet, Last Name was in column B, first name was in C, and middle name is in D. I then combined them into one column (E) using this formula:
=B2 & " " & C2 & " " & D2
I’m trying to figure out how I can add a comma after the last name. I tried a few things, like inserting a comma into the formula, but it didn’t work.
Anyone have any ideas?