hat
Si ou gen yon seri selil ki gen alfabetik, nimerik ak karaktè lòt, epi kounye a ou bezwen retire tout karaktè ki pa-nimerik ak sèlman kenbe karaktè yo nimerik nan selil yo. Pa egzanp, pou chanje Amerik 34-12234 @ 2212 * yo 34122342212 apre yo fin retire karaktè ki pa-nimerik. Ou ka fè li jan sa a:
eng
If you have a range of cells containing alphabetic, numeric and other characters, and now you need to remove all non-numeric characters and only keep the numeric characters in the cells. For example, to change America 34-12234@2212* to 34122342212 after removing non-numeric characters. You can do it as follows: