kraken-chris/translate-into-inches

Created May 9, 2023 16:04

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/kraken-chris/534bd83a1421eff02798519c4204fd56.js"></script>
Save kraken-chris/534bd83a1421eff02798519c4204fd56 to your computer and use it in GitHub Desktop.

Download ZIP

Spreadsheet formula to translate various lengths into inches. Supports: ", ft, mm, m

Raw

translate-into-inches

=IF(ISNUMBER(SEARCH("""",B2)), LEFT(B2,LEN(B2)-1), IF(ISNUMBER(SEARCH("mm", B2)),LEFT(B2, LEN(B2)-2) / 25.4,IF(ISNUMBER(SEARCH("M", B2)),LEFT(B2, LEN(B2)-1) * 39.37,IF(ISNUMBER(SEARCH("ft", B2)),LEFT(B2,LEN(B2)-2) * 12,B2))))

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