I am using the following code in many cells of the sheet,
=SPLIT(REGEXREPLACE("" & S2, "(\d)", "$1,"), ",")
not all are going to contain data at any one time. How do I stop the empty cell value notice from appearing?
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community