— CAN YOU SOLVE THIS - EXCEL CHALLENGE 127 —
(Solutions in any language are also welcome for Excel Challenges)
Remove LSTRIP Chars from Input String from left side. Characters in LSTRIP Chars will be treated individually. Hence, “abc” means “a” or “b” or “c”.
Hence, if any of the characters from LSTRIP Chars appear from left side they are removed till they encounter a character other than LSTRIP Chars in Input String.
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/d2hid4he
#excel, #excelchallenge, #powerquerychallenge, #daxchallenge, #m, #dax, #powerbi, #powerquery, #powerpivot, #sheets, #googlesheets, #data, #analytics, #businessintelligence, #finance, #office365, #python, #r
Excel BI’s LinkedIn Post