1 min readfrom 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.

submitted by /u/depressionNcheese
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article