Reply To: Export to NODE XL
Home › Forums › Advanced usage › Export to NODE XL › Reply To: Export to NODE XL
April 11, 2016 at 2:33 pm
#700
Barri
Participant
Hi,
I have tested the formulas and do not work in this version.
1º. DELETE FILE A
2º
=EXPAND(ArrayFormula(LOWER(A2:A))) ERROR
=ArrayFormula(LOWER(A2:A)) CORRECT
3º
=EXPAND(ArrayFormula(IF(LEFT(E2:E,1)=”@”,MID(E2:E,2,FIND(” “,E2:E)-2),))) ERROR
I can not find the right formula
4º
=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