•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to use TEXTSPLIT() on a range?
Suppose I have a 6-row x 1-col array -- in A1:A6, say -- where each cell contains a sequence of four letters separated by commas. For example:
A1="a,b,c,d"
A2="e,f,g,h"
...
A6="u,v,w,x"
I want to produce from that a 6-row x 4-col dynamic array where each row consists of what you'd get if you ran TEXTSPLIT(<cell>,",") on each cell in the original array.
Why does this not work:
=BYROW(A1:A6, LAMBDA(row, TEXTSPLIT(row,",")))
And how should it be done?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#row zero
#no-code spreadsheet solutions
#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#TEXTSPLIT
#dynamic array
#comma separated values
#BYROW
#LAMBDA
#array formula
#Excel
#data manipulation
#cell reference
#dynamic range
#function
#output array