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

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

Want to read more?

Check out the full article on the original site

View original article

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