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:
In both cases the result is: Doe...