Công thức bỏ dấu là:
=ArrayFormula(Regexreplace(Regexreplace(Regexreplace(Regexreplace(Regexreplace(Regexreplace(Regexreplace(A2:A3;"[áàạảãăắằặẳẵâấầậẩẫ]";"a");"đ"
;"d");"[éèẹẻẽêếềệểễ]";"e");"[íìịỉĩ]";"i");"[óòọỏõôốồộổỗơớờợởỡ]";"o");"[úùụủũưứừựửữ]";"u");"[ýỳỵỷỹ]";"y"))
Nguồn tham khảo:
https://www.thuthuatexcel.com/2021/10/bo-dau-tieng-viet-trong-google-sheets.html