Reply To: Export to NODE XL

Home Forums Advanced usage Export to NODE XL Reply To: Export to NODE XL

#700
Barri
Participant

Hi,

I have tested the formulas and do not work in this version.

1º. DELETE FILE A


=EXPAND(ArrayFormula(LOWER(A2:A))) ERROR
=ArrayFormula(LOWER(A2:A)) CORRECT


=EXPAND(ArrayFormula(IF(LEFT(E2:E,1)=”@”,MID(E2:E,2,FIND(” “,E2:E)-2),))) ERROR
I can not find the right formula


=EXPAND(ArrayFormula(LOWER(IF(D2:D=””,A2:A,D2:D)))) ERROR
=ArrayFormula(LOWER(IF(D2:D=””,A2:A,D2:D))) CORRECT

I do not get it to work 🙁 🙁 🙁

can you help me?
barri