Quickly extract numbers only from text strings in Excel

preview_player
Показать описание
#exceltips #exceltricks #excelformula
Рекомендации по теме
Комментарии
Автор

Formula for all versions:=LOOKUP(9.9E+307, --LEFT(MID(A2, MIN(FIND({1, 2, 3, 4, 5, 6, 7, 8, 9, 0}, $A2&"1023456789")), 999), ROW(INDIRECT("1:999"))))

ExtendOffice
Автор

Formula for Excel 365: =REGEXEXTRACT(A2, "[\d.]+")

ExtendOffice
visit shbcf.ru