Hello.
I have a bit of an issue. I am trying to combine a first name and last name with a comma in between. For example, I need Jane Doe to become Doe, Jane.
Cell C1 is Jane
Cell D1 is Doe
I have used these formulas:
=D1&","&C1
=CONCATENATE(D1,",",C1)
In both cases the result is: Doe...