TEXT Functions Secret in Excel

in Excel you can use TEXT Function to Extract Numbers and Text

➡️Numbers :
✅=BYROW(TEXT(MID(B8:B30,SEQUENCE(,99),1),”0;;0;”),CONCAT)

➡️Text:
✅=BYROW(TEXT(MID(B8:B30,SEQUENCE(,99),1),”;”),CONCAT)

➡️in one Formula :

✅=LET(SPLIT,MID(B8:B30,SEQUENCE(,99),1),fn,CONCAT,
HSTACK(BYROW(TEXT(SPLIT,”0;;0;”),fn),BYROW(TEXT(SPLIT,”;”),fn)))

OR

✅=WRAPROWS(BYROW(DROP(REDUCE(“”,B6:B28,LAMBDA(x,y,VSTACK(x,TEXT(MID(y,SEQUENCE(,99),1),{“0;;0;”;”;”})))),1),CONCAT),2)

➡️and if you want to reorder the cell (number +letters)
for example :

PV25000MOTJ >>> 25000PVMOTJ

✅=BYROW(MID(B8:B30,SEQUENCE(,99),1),LAMBDA(X,CONCAT(TEXT(X,{“0;;0;”;”;”}))))

for sure there are many ways to do the same , but here I am talking about TEXT function

inspired by Rick Rothstein