Use Flash Fill: type the desired text in one column and the numbers in another, then press Ctrl+E
Use formulas to extract text: `=TEXTJOIN(“”,TRUE,IF(ISERR(MID(A1,ROW(INDIRECT(“1:”&LEN(A1))),1)*1),MID(A1,ROW(INDIRECT(“1:”&LEN(A1))),1),””))`
Use formulas to extract numbers: `=TEXTJOIN(“”,TRUE,IF(ISNUMBER(MID(A1,ROW(INDIRECT(“1:”&LEN(A1))),1)*1),MID(A1,ROW(INDIRECT(“1:”&LEN(A1))),1),””))`
Use Text to Columns with delimiters if text and numbers are separated by spaces, commas, or other symbols
Use Power Query to split columns by digit/non-digit patterns
Use VBA to loop through each character and separate letters from digits
Use helper columns with MID, ROW, LEN, and IF functions to isolate characters
Use Find and Replace to remove either text or numbers when only one part is needed