Add Full stop to all cells

[Manolocs]

I have this extensive list some of it already have a full stop at the end of the phrase, I need to insert the (.) at the end of the cells that do not have full stop already.
Any help is more than welcome. If possible with formulas would be very appreciated. Thanks in advance

 

[Joe4]

Related to what Blunder1 says, I have sometimes seen "special" non-visible characters at the end of data, especially data copied/downloaded from the web.

If you have an entry in G7 that ends with a period (.), see what this formula returns:
=CODE(RIGHT(G7,1))

If it returns anything other than 46, then your entry does not end in a regular period. The number the formula returns will tell us what it is (from the ASCII list referenced here): Ascii Table - ASCII character codes and html, octal, hex and decimal chart conversion

 

[Manolocs]

Thank you Blunder, exactly what I needed

 

[István Hirsch]

Give this a try:

=A1&IF(RIGHT(A1,1)<>".",".","")

 

[Manolocs]

@Joe4, Hi sorry for the other post, but is different from this, in the other I want do delete the full stop, in this I want to add full stop, anyway Mr Blunder found the exact solution. Thank you for your help.

 

[Joe4]

Joe4, Hi sorry for the other post, but is different from this, in the other I want do delete the full stop, in this I want to add full stop, anyway Mr Blunder found the exact solution. Thank you for your help

It looked like you were trying to approach the same problem coming at it from a similar but somewhat different angle.
If that is not the case, and you still need the other question answered, let me know and I will unlock it.

 

[István Hirsch]

how about this formula?
=SUBSTITUTE(G7,".","")&"."

This removes existing periods if they exist and adds one to the end. Only issue with this is if your string has multiple full stops in it; it will remove them all. For example:
"Hi, I live in Canada. It is cold today." will be changed to "Hi, I live in Canada It is cold today."

Substitute seems to work in this form:

=SUBSTITUTE(A1&".","..",".")

 

[Manolocs]

@Joe4 You are right, I was trying to fix in another angle, but the problem is solved. Don't need the other one, Thanks for the information