Skip to content

Instantly share code, notes, and snippets.

@zenideas
Last active March 24, 2023 17:37
Show Gist options
  • Save zenideas/7a3612566454ccf6b053afc778f44dab to your computer and use it in GitHub Desktop.
Save zenideas/7a3612566454ccf6b053afc778f44dab to your computer and use it in GitHub Desktop.
I am assuming that you have some text or numbers where you want to replace Bengali numerals ০১২৩৪৫৬৭৮৯ to 0-9. Put that text or number in cell J15 and try this formula in cell K15.
/* Original vba script was from https://support.google.com/docs/thread/65089055/sheets-bengali-number?hl=en I just reversed for the reversed result.*/
=arrayformula(
concatenate(
iferror(
vlookup(
mid(J15, row(J$1:J), 1),
{
mid("০১২৩৪৫৬৭৮৯", row(J$1:J), 1),
mid("0123456789", row(J$1:J), 1)
},
2,
false
),
mid(J15, row(J$1:J), 1)
)
)
/* Alternate formula which works for GoogleSheets ad Excel alike*/
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"0","০"),"1","১"),"2","২"),"3","৩"),"4","৪"),"5","৫"),"6","৬"),"7","৭"),"8","৮"),"9","৯")
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment