"ivano" schrieb im Newsbeitrag
...
"Frank Kabel" ha scritto nel messaggio
...
Hi
try the follo´wing array formula (entered with CTRL+SHIFT+ENTER):
=LEFT(A1,MIN(IF(ISNUMBER(-MID(A1,seq,1)),seq)-1)
where seq is the defined name with the formula:
=ROW(INDIRECT("1:1024"))
hy Frank,
I think you have lost a "-" in your formula:
=LEFT(A1,MIN(IF(ISNUMBER(--MID(A1,seq,1)),seq)-1)
Hi
no this was intentioanlly :-)
No need for a second '-' sign as I just test if the returned character
is a number and I don't care about the sign of this number for this
comparison.
Frsnk
|