excel中取数字（Take numbers in Excel）.docVIP

excel中取数字（Take numbers in Excel） Take the front Data in A1 Input at B1 =LOOKUP (9E+307, --MID (A1, MIN) (FIND ({0,1,2,3,4,5,6,7,8,9}, A1, 0123456789)), ROW (INDIRECT (1:, LEN, A1))) Downward support Go behind Data in A1 Input at B1 =SUBSTITUTE (A1, LOOKUP (9E+307, --MID) (A1, A1, MIN (FIND ({0,1,2,3,4,5,6,7,8,9}, A1, 0123456789)), ROW (INDIRECT (1:, LEN,))) Downward support My formula is actually a formula for numbers and numbers, and your numbers are in front and back If you only want the front one Can use Front =LEFT (A1, SEARCH ( , A1)) behind =RIGHT (A1, LEN (A1), -SEARCH ( , A1)) Table Ex