Skip to content

Instantly share code, notes, and snippets.

@shawonis08

shawonis08/Google Sheets Number Translation Formula.md

Last active February 15, 2023 07:14
Show Gist options
  • Save shawonis08/31094dbfcef6248aeef017c1873097c7 to your computer and use it in GitHub Desktop.
Save shawonis08/31094dbfcef6248aeef017c1873097c7 to your computer and use it in GitHub Desktop.
Download ZIP
convert the numerical values of one language to those of another. In order to accomplish the translation, the formula makes use of the vlookup and mid functions. The formula is included in the guide, as well as a link to the primary support post where the topic was initially brought up.
Raw
Google Sheets Number Translation Formula.md

Google Sheets Number Translation Formula

=arrayformula( 
  concatenate( 
    iferror( 
      vlookup( 
        mid(A1, row(A$1:A), 1), 
        { 
          mid("0123456789", row(A$1:A), 1), 
          mid("০১২৩৪৫৬৭৮৯", row(A$1:A), 1) 
        }, 
        2, 
        false 
      ), 
      mid(A1, row(A$1:A), 1) 
    ) 
  ) 
)

Reference

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment