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

Tagged with

#AI formula generation techniques
#rows.com
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#formula generator
#Excel compatibility
#Excel alternatives
#natural language processing for spreadsheets
#generative AI for data analysis
#TEXTSPLIT
#formula
#MAP
#LAMBDA
#dynamic
#separate cells
#Excel
#cell value
#pattern
#IFERROR
#numbers