add period when needed

[Manolocs]

Hello,
I am trying to fix period when needed, but take in consideration "," ":" "?" when inserting.
The formula I am trying to use is the below but it is adding another period at the end, and inserting a period when the cell is empty.
This formula was made by Special-k99 in another thread.
Thanks in advance

[COLOR=#333333]=trim(b1)&if(or(right(trim(b1),1)=":",right(trim(b1),1)="?"),"",".")[/COLOR]

 

[Manolocs]

The problem with cell A1 is that those three dots are not three individual dots, they are a single character called an ellipsis (which Excel automatically substitutes when it sees three adjacent dots). In the following formula, I simply added the ellipsis character to the list of terminating characters inside the FIND function)...

=TRIM(A1)&IF(ISNUMBER(FIND(RIGHT(TRIM(A1)),".,:?!…")),"",".")

You highlighted cell A5 in red... was that supposed to indicate my formula returned the wrong value? If so, what should it have returned?

Hello Rick Rothstein, the red in the A5 is wrongly set.
It is working but the idea is to eliminate the dots in excess and leave only one.
please if you change any one of the cell in the column A to end with a "," you will notice that does not add the period after.
Thanks for your time.