I have Excel 365. They just added the REGEXTRACT formula to my Excel. I am using the formula to extract numbers. Is there a way to extract all numbers from a text string, not just the first group of numbers?
Cell Formulas | ||
---|---|---|
Range | Formula | |
B2:B4 | B2 | =REGEXEXTRACT(A2,"\d+") |