— CAN YOU SOLVE THIS - EXCEL CHALLENGE 131 —
(Solutions in any language are also welcome for Excel Challenges)
The strings given in column A have some alphabets which are masked i.e. replaced by asterisks.
The alphabets corresponding to those asterisks are given in column B.
Replace asterisks by corresponding characters of column B.
Hence, if string is “Go* is **eat” and chars is “dGr”, then answer would be “God is Great”.
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/d4SUBuFs
#excel, #excelchallenge, #powerquerychallenge, #daxchallenge, #m, #dax, #powerbi, #powerquery, #powerpivot, #sheets, #googlesheets, #data, #analytics, #businessintelligence, #finance, #office365, #python, #r
Excel BI’s LinkedIn Post