Extracting 7-digit number from text string

Syed_001 There are a few different approaches you could take, depending on if certain conditions are always true...

If the text strings will only ever contain ONE numeric value per string (ie: "1004925" is numeric, while "XXXXXX7209" and "JSC6896" are not), you could use:

=SUM(IFERROR(--TEXTSPLIT(C3, " "), 0))

However, this method runs the risk of adding multiple numbers together, if there's a possibility of two or more actual numbers appearing in a single string. If that's the case, but the number you require will always be the maximum value, you could replace SUM with MAX:

=MAX(IFERROR(--TEXTSPLIT(C3, " "), 0))

Alternatively, if the number you require will always be the minimum numeric value in the string, you could use MIN, but replace 0 with "":

=MIN(IFERROR(--TEXTSPLIT(C3, " "), ""))

If none of the above scenarios are always true, you could use the LET function to define the array of values resulting from TEXTSPLIT, then FILTER the array by the appropriate conditions:

=LET(arr, IFERROR(--TEXTSPLIT(C3, " "), 0), FILTER(arr, (arr>=1000000)*(arr<=2000000), ""))

Lastly, if there's still a chance that multiple numeric values may appear in a single string, between 1000000 and 2000000, you may also want to use TEXTJOIN to return all matching values in a delimited string:

=LET(arr, IFERROR(--TEXTSPLIT(C3, " "), 0), TEXTJOIN(", ", TRUE, FILTER(arr, (arr>=1000000)*(arr<=2000000), "")))