Find and replace Regex

[CalDowd98]

Hi all

I have chunks of texts where the character  is coming before every instance of ².

Is there a way of replacing the special character, and then closing the gap ?

EG CO² will become CO²

Thank you !!

[LordNeilLord · Accepted solution]

Hey @CalDowd98 

You could try something like this:

Replace([Field1], CharFromInt(194), "")

194 is Â, i found this number by spliting out your text into individual characters and then using CharToInt() to find the number 🙂

[CalDowd98]

Wow !

Thats worked perfectly, thank you  !!