Forum Discussion

Jammin2082's avatar
Jammin2082
Copper Contributor
Jul 21, 2022
Solved

Translating Morse code in Excel

Hi,   I am working on a Morse code translator in Excel with my son. I want to get rid of the FALSE messages in the cell. Can anyone help me?   In Morse code the dots are represented with "." and ...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Jul 21, 2022

    Jammin2082 

    Perhaps

    =
IF(B3=".\",    "A",
IF(B3="\...",   "B",
IF(B3="\.\.",   "C",
IF(B3="\..",    "D",
IF(B3=".",      "E",
IF(B3="..\.",   "F",
IF(B3="\\.",    "G",
IF(B3="….",     "H",
IF(B3="..",     "I",
IF(B3=".\\\",   "J",
IF(B3="\.\",    "K",
IF(B3=".\..",   "L",
IF(B3="\\",     "M",
IF(B3="\.",     "N",
IF(B3="\\\",    "O",
IF(B3=".\\.",   "P",
IF(B3="\\.\",   "Q",
IF(B3=".\.",    "R",
IF(B3="…",      "S",
IF(B3="\",      "T",
IF(B3="..\",    "U",
IF(B3="…\",     "V",
IF(B3=".\\",    "W",
IF(B3="\..\",   "X",
IF(B3="\.\\",   "Y",
IF(B3="\\..",   "Z", "error")
)))))))))))))))))))))))))
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 21, 2022

Jammin2082 

Perhaps

=
IF(B3=".\",    "A",
IF(B3="\...",   "B",
IF(B3="\.\.",   "C",
IF(B3="\..",    "D",
IF(B3=".",      "E",
IF(B3="..\.",   "F",
IF(B3="\\.",    "G",
IF(B3="….",     "H",
IF(B3="..",     "I",
IF(B3=".\\\",   "J",
IF(B3="\.\",    "K",
IF(B3=".\..",   "L",
IF(B3="\\",     "M",
IF(B3="\.",     "N",
IF(B3="\\\",    "O",
IF(B3=".\\.",   "P",
IF(B3="\\.\",   "Q",
IF(B3=".\.",    "R",
IF(B3="…",      "S",
IF(B3="\",      "T",
IF(B3="..\",    "U",
IF(B3="…\",     "V",
IF(B3=".\\",    "W",
IF(B3="\..\",   "X",
IF(B3="\.\\",   "Y",
IF(B3="\\..",   "Z", "error")
)))))))))))))))))))))))))

Resources