— CAN YOU SOLVE THIS - EXCEL CHALLENGE 128 —
(Solutions in any language are also welcome for Excel Challenges)
Insert a space whenever there is a transition from alphabet to number OR number to alphabet in the strings.
Hence if string is “wer12ty”, then space will entered between r and 1 & 2 and t. Hence answer will be “wer 12 ty”.
For row 7, underscore in the answer is by mistake. It is space only. Corrected in the Excel.
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/duu7-3gP
#excel, #excelchallenge, #powerquerychallenge, #daxchallenge, #m, #dax, #powerbi, #powerquery, #powerpivot, #sheets, #googlesheets, #data, #analytics, #businessintelligence, #finance, #office365, #python, #r
Excel BI’s LinkedIn Post