Excel BI Challenge Workout 125

— CAN YOU SOLVE THIS - EXCEL CHALLENGE 125 —
(Solutions in any language are also welcome for Excel Challenges)

Convert given strings into Morse codes.

  1. This is case insensitive.
  2. Mapping table of alphabets and numbers is on right side.
  3. Mars code for space will be “/”
  4. There will always be a space between two morse codes. Hence ab will be “.- -…” not “.–…”. Notice a space between “.-” and “-…”

Post answers in Comment.

(Your formula need not be a single formula. You can write multiple formulas to arrive at a solution. Also your formula need not be different from others as long as you have worked out your formula independently)

Download Practice File - https://lnkd.in/dNqAcJRX

#excel, #excelchallenge, #powerquerychallenge, #daxchallenge, #m, #dax, #powerbi, #powerquery, #powerpivot, #sheets, #googlesheets, #data, #analytics, #businessintelligence, #finance, #office365, #python, #r

Excel BI’s LinkedIn Post