Is there a way to make the cell show the array?
For example, in cell B1, i have a formula and when i click F9 it shows {"D";"a";"v"}.
Can I somehow make cell B1 show "av"??
Thanks in advance.
Reason: I'm trying to alternate between upper and lower case of a text. In Cell A1, i have "David"
My formula in B1 is =IF(ISODD(ROW(INDIRECT("1:"&LEN(A1)))),UPPER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),LOWER(MID(A1,ROW(INDIRECT("1:"&LEN(A1)),1)))
Im trying to make B1 show "DaViD"
For example, in cell B1, i have a formula and when i click F9 it shows {"D";"a";"v"}.
Can I somehow make cell B1 show "av"??
Thanks in advance.
Reason: I'm trying to alternate between upper and lower case of a text. In Cell A1, i have "David"
My formula in B1 is =IF(ISODD(ROW(INDIRECT("1:"&LEN(A1)))),UPPER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),LOWER(MID(A1,ROW(INDIRECT("1:"&LEN(A1)),1)))
Im trying to make B1 show "DaViD"