Forum Discussion
Applying a Formula to one column in a returned array
I have a TEXTSPLIT function returning an array of data for me, but one of these pieces of data is a date in dd.mm.yyyy format. I can easily make a formula to correct that and put it in an excel recog...
It is hard to know without more information like what does all the other data look like? But let's say all the other data is proper dates then maybe:
=LET(origFormula, TEXTSPLIT(...), IF( ISNUMBER(origFormula), origFormula, SUBSTITUTE(origFormula, ".", "/")))
=LET(origFormula, TEXTSPLIT(...), IF( ISNUMBER(origFormula), origFormula, SUBSTITUTE(origFormula, ".", "/")))