Extract Text and Numbers from String in Excel with LET, SEQUENCE, MID, CONCAT #Excel Functions For Text Only: =LET(X,MID(B4,SEQUENCE(LEN(B4)),1),CONCAT(IF(ISNUMBER(--X),"",X))) For Numbers Only: =LET(X,MID(B4,SEQUENCE(LEN(B4)),1),CONCAT(IF(ISERR(--X),"",X))) | Excel Basement

Dynamically Extract Data Columns based on String in Excel with CHOOSECOLS & TEXTSPLIT Function | #Excel 365 For Numbers Based Columns Selection =CHOOSECOLS(Data[#All],--TEXTSPLIT(D4,",")) For Text Based Columns Selection =LET( headers, B15:F15, requestedHeaders, TEXTSPLIT(D4, ", "), colIndices, MAP(requestedHeaders, LAMBDA(h, MATCH(h, headers, 0))), CHOOSECOLS(B15:F21, colIndices)) | Excel Basement