Before I had access to Excel 2016 (365), I made a comment on Chris Webb’s web site about a possible use for the new TEXTJOIN function.
Here is the comment:
… the following array formula will return a numeric string from a string (i.e. – 125 from AMDHF125KOI) by using this formula. =TEXTJOIN(“”,TRUE,IFERROR(VALUE(MID(A1,ROW(INDIRECT(“1:”&LEN(A1))),1)),””))
Chris confirmed that it worked!
Afterwards, I forgot about it, until I read the article on XOR LX’s web site about extracting numbers from a string.
In looking at the comparisons, I saw that this TEXTJOIN formula construction simplified the extraction of an internal numeric string from a string as compared to previous solutions.
I am looking at ways to extend this methodology to other string-to array-to string solutions.