https://bugs.documentfoundation.org/show_bug.cgi?id=138749
--- Comment #9 from Óvári <[email protected]> --- How to write recursive LAMBDA function in Excel with examples ============================================================= https://www.ablebits.com/office-addins-blog/write-recursive-lambda-function-excel/ Example 1. Remove unwanted characters and trim extra spaces ----------------------------------------------------------- =LAMBDA(data, chars, TRIM(IF(chars<>"", RemoveTrim(SUBSTITUTE(data, LEFT(chars, 1), ""), RIGHT(chars, LEN(chars) -1)), data))) =RemoveTrim(A2:A10, D2) Example 2. Replace multiple characters with the same character -------------------------------------------------------------- =LAMBDA(data, chars, new_char, IF(chars<>"", ReplaceChars(SUBSTITUTE(data, LEFT(chars), new_char), RIGHT(chars, LEN(chars)-1), new_char), data)) =ReplaceChars(A2:A6, E1, E2) Example 3. Replace multiple values with other values at once ------------------------------------------------------------ =LAMBDA(data, old, new, IF(old<>"", ReplaceAll(SUBSTITUTE(data, old, new), OFFSET(old, 1, 0), OFFSET(new, 1, 0) ), data)) =ReplaceAll(A2:A10, D2, E2) -- You are receiving this mail because: You are the assignee for the bug.
