Braille Translator Challenge

Using the Braille Alphabet lookup table provided: Part 1 - convert the given phrase from Braille to words. Part 2 - convert the given phrase from words to Braille. ✅ Solutions should be in the f...

braille_translator_challenge.xlsx15 KB

excel

Formulas and Functions

office 365

IlirU

Iron Contributor

Aug 12, 2026

Hi djclements,

(I have not used the LAMBDA function in my formula)

I applied the first formula to cell AF10.

=LET(
     data, B3:Q18,
   phrase, T5:BS7,
           CONCAT(XLOOKUP(BYCOL(WRAPCOLS(BYCOL(phrase, ARRAYTOTEXT), 2), ARRAYTOTEXT),
           HSTACK(BYCOL(WRAPCOLS(BYCOL(CHOOSEROWS(data, {2,3,4}), ARRAYTOTEXT), 2), ARRAYTOTEXT),
                  BYCOL(WRAPCOLS(BYCOL(CHOOSEROWS(data, {6,7,8}), ARRAYTOTEXT), 2), ARRAYTOTEXT),
                  BYCOL(WRAPCOLS(BYCOL(CHOOSEROWS(data, {10,11,12}), ARRAYTOTEXT), 2), ARRAYTOTEXT),
                  BYCOL(WRAPCOLS(BYCOL(CHOOSEROWS(data, {14,15,16}), ARRAYTOTEXT), 2), ARRAYTOTEXT)),
           HSTACK(
                  TOROW(CHOOSEROWS(data, 1), 1),
                  TOROW(CHOOSEROWS(data, 5), 1),
                  TOROW(CHOOSEROWS(data, 9), 1),
                  TOROW(CHOOSEROWS(data, 13), 1)
))))

The second formula is the same as the first formula, but instead of T5:BS7, T19:BS21 should be inserted in the formula.

Try it and let me know.

IlirU