•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Schrodinger's blank cell. What causes this value to echo differently than others when referenced.
d3:e7 are data entered
g3 down to g7 is
=TEXTSPLIT(TEXTJOIN(",",,D3&","&SUBSTITUTE(E3,",",","&D3&",")),",")
m3 is
=G3:K8 and as expected, blank cells convert to zeros
look at n6 it is not a zero... but-- look at the formulas below as applied to h6
it's not 'blank' (i14/k14) but it is equal to a blank cell (i17/k17)
what is it? if I click it- it lights up as a spill cell from the left.. but why didn't it make n6 as a zero? (which is what caught my eye)
(edit, and you are all NUTS with your convoluted solutions to
https://www.reddit.com/r/excel/comments/1r2aqid/how_to_split_strings_and_join_values/ )
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#rows.com
#Excel compatibility
#row zero
#big data management in spreadsheets
#generative AI for data analysis
#enterprise-level spreadsheet solutions
#conversational data analysis
#AI-driven spreadsheet solutions
#real-time data collaboration
#financial modeling with spreadsheets
#intelligent data visualization
#no-code spreadsheet solutions
#Schrodinger's cell
#blank cell
#spill cell
#TEXTSPLIT
#TEXTJOIN
#Excel
#data entered