601 votes39 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Thanks for the suggestion! We’re fans of Regex and its ability to parse text too.
If you’d like to see Regex support in Excel, please keep the votes rolling in.
- JoeMcD [MS XL]Any Mouse supported this idea ·
An error occurred while saving the commentAny Mouse commented
Since REGEX is such a multifaceted animal, I wish to express my interest in at least having the functionality to cull a formatted sub-string from another cell. Something like =LEFT(A5, 11), except that I don't know where in the string the 11 characters that I want will be (based on format). This is for pulling specific information out of user entered data. The point is, I am not looking for find or find/replace, which is interactive, or for a filter; I am looking to extract consistently formatted information from inconsistently entered data, applied in every row of data provided.