•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