I need some help with a caluclated column. My formula looks like this, and so far it is working.
But The data shown if Column1 = Sweden, contains a “-” in the middle, I want to remove this “-” from every entry that has Sweden in Column1.
I can’t seem to figure this out, I’ve tried a lot of variations but it does not work for me.
Thank you from Sweden