Reversing the words in a cell

well, that's what it does!!

Hello JvDO

Your formula returns only #VALUE
On the other hand, the one from Vaucluse works for replacing "comma + a space" with a point, but the last name remains before the first name.

Just reverse the two items and it should be fine:

=RIGHT(A1,LEN(A1)-FIND(",",A1,1)-1)"."&LEFT(A1,FIND(",",A1,1)-1)


Note that this formula is identical to that of JvDO, it also returns a value if the reference cell does not contain text or a comma (the difference" likely comes from the fact that JvDO used C5 instead of A1 and you may not have paid attention to it)

to avoid that, you can "protect" it:

=IF(ISERROR(FIND(",",A1,1),"",RIGHT(A1,LEN(A1)-FIND(",",A1,1)-1)"."&LEFT(A1,FIND(",",A1,1)-1))

best regards

Thank you very much, it works.
Indeed, it came from "C5" instead of "A1," but since I’m a total klutz with Excel, I didn’t even notice.

Thanks again to everyone
Have a great day

OK, I mark the topic as resolved and let's give a little thanks to JvDO, first on the field by a minute
Safe travels