XTRACT

[lrobbo314]

XTRACT returns either letters or numbers from a given string.

There are different and maybe better or more concise ways to extract letters or numbers from a string. I just thought this was kind of a clever solution and cool that it lets you flip between returning numbers or letters.

=LAMBDA(
    text,[num_or_text],
    TAKE(
        SCAN(
            text,
            SEQUENCE(LEN(text)),
            LAMBDA(
                a,b,
                RIGHT(a,LEN(a)-1)
                &IF(
                    XOR(
                        ISNUMBER(LEFT(a)+0),
                        num_or_text
                    )
                    ,LEFT(a),
                    ""
                )
            )
        ),
        -1
    )
)

XTRACT
	A	B	C
1	ABC123	123	ABC
2	456DEF	456	DEF
3	1a2b3c	123	abc
4	x7y8z9	789	xyz
Sheet6

Cell Formulas
Range	Formula
B1:B4	B1	=XTRACT($A1)
C1:C4	C1	=XTRACT($A1,1)