Assuming that A2 contains the text string, and numbers occur together, maybe...



B2:



=MID(A2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&"0123456789")),SUM(LEN(A2)-LEN(SUBSTITUTE(A2,{1,2,3,4,5,6,7,8,9,0},""))))



C2:



=SUBSTITUTE(A2,B2,"")

이 게시물을...