•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
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