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