hat
Aktyèlman, ou ka dirèkteman antre nan fòmil = EXTRACTNUMBERS (A1, verite) or = EXTRACTNUMBERS (A1) (A1 se selil la ak nimewo ak kòd tèks melanje) nan yon selil vid, epi trennen Manch nan ranpli nan seri a ou bezwen.
eng
Actually, you can directly enter formula =EXTRACTNUMBERS(A1,TRUE) or =EXTRACTNUMBERS(A1) (A1 is the cell with numbers and text string mixing) in a blank cell, and drag the Fill Handle to the range you need.