Excel: Convert text to numbers
Excel 2016 or newer =TEXTJOIN("",TRUE,IFERROR((MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1)*1),"")) Then copy that column to a new column - selecting values only Then note the error/note talking about numbers stored as text, and fix that. REF: https://trumpexcel.com/extract-numbers-from-string-excel/#Extract-Numbers-from-String-in-Excel-Formula-for-Excel-2016