Forum Discussion
TEXTSPLIT combined with BYROW returns an unexpected result when using an array of strings as input
I have the following formula: =LET(input, {"a,b;c,d;" ; "e,f;g,h;"},
BYROW(input, LAMBDA(item, TEXTJOIN(";",,TEXTSPLIT(item,",",";", TRUE))))) expecting the get the input back b...
Perhaps this https://techcommunity.microsoft.com/t5/excel/byrow-function-produces-two-different-results-depending-on/m-p/3679875/highlight/false#M171199 discussion helps.
BYROW() passes to lambda item as an array from one element, and MAP() - value. If you use @item in BYROW it shall work, didn't test.