What is this comma doing?!

[Emma Eve]

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 ,Jane. How to I get the comma in the right place?

Thank you!

Emma

 

[Dryver14]

=D1&", "&C1

" then, then space then"

 

[Marcelo Branco]

Try

=TRIM(D1)&","&TRIM(C1)

M.

 

[JazzSP8]

Does it have trailing spaces?

Try

=TRIM(D1)&", "&TRIM(C1)

?

 

[Emma Eve]

Hi. Thank you for the reply. I copied the formula in and the result is: Duff , Aaron. I'm still messing up, aren't I?

 

[Jonmo1]

There is a character at the end of D1 after the name you see in it, previous answers assumed it was a space.
But if the suggested solutions didn't work, then it's NOT a space.

What does this return

=CODE(RIGHT(D1,1))

 

[philwojo]

Whose formula did you use? The one from post #2 , I would expect to possibly give you the same results, either formula from post 3 or 4 should give you the result you would want though.

 

[Emma Eve]

Jonmo1 - you nailed it. There was a space hiding out behind the last night. I got rid of it and now the formula returns the desired results. Thank you all so much!

 

[Jonmo1]

You're welcome