When I use SPLIT function, the data in my cell gets converted from TEXT to Number (notice the preceding '0' in cell C3 is removed).
is there a way to retain the data as Text after the split (or at least retain the 0 in front) ?
=SPLIT( JOIN("!",B1:B), "!")