I have a problem with a Google Sheet.
I use docpaser to read incoming pdf files - doc parser reads 8 pieces of information in each pdf file and adds a new row to a Google Sheet with the information in 8 columns (A:H).
Its working excellent - however in a text column (C) I have a problem.
Due to language (Danish) we have 3 extra letters Æ Ø Å wich the docparser don't read and send correct to the Google Sheet row.
Only if there is either a Æ, Ø or Å there is a problem.
each letter Æ, Ø or Å is wrongfully read/added to the Google Sheet row, ex:
Æ: Ræv is added as RÃƒÂ¦v - I need to the sheet to automaticical replace "ÃƒÂ¸" with Æ Ø: "Brød" is added as BrÃƒÂd - I need to the sheet to automaticical replace "ÃƒÂ¸" with Ø Å: "Råd" is added as RÃƒÂ¥d - I need to the sheet to automaticical replace "ÃƒÂ¥" with Å
I know I can manipulate it via formulas, but I would like to avoid making extra colums in the sheet and have this done automatically when a row is added (without to run a manual macro ect - if possible.
Thanks in advance for your input, Casper