Adding a full stop/period to end of each cell if there isn't already one there.

[Smiggels]

Hey all,

So I'm looking for a formula which will add a period/full stop to the end of each cell. I understand you could use =A1&".", however this adds the full stop again if there is already one present resulting in A1 & ..

Main problem is finding a formula which will recognise if the full stop is already present.

Thanks for any help

[Ace_XL]

Try

Please Login or Register  to view this content.

or another way (if you have "." only at the end of the sentence

Please Login or Register  to view this content.

[Smiggels]

That worked great!

Adds full stops to the end of each sentence but ignores cells which already have one.

Thanks Axe_XL.