•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
I think I need to use MAP and LAMBDA for an output I want, but the formula I came up with is not working.
Column B has values which follow a specific pattern, which is:
numbers.numbers.numbers.text.00000.0000.000000
I want each aspect of the cell value in seperate cells, I can use TEXTSPLIT with the "." delimiter to achieve this. The output is exactly what I want. And the current working formula I'm using is:
=IFERROR(TEXTSPLIT (B2,"."),"")
But when I try to apply MAP and LAMBDA to make this dynamic and not needing a drag it shows a #calc error
What I'm using:
=MAP(DROP(B:.B,1),LAMBDA(x,TEXTSPLIT(x,".")))
I don't understand what I'm doing wrong here, let me know if you want more info.
[link] [comments]
Want to read more?
Check out the full article on the original site