Feedback by UserVoice

Any Mouse

My feedback

  1. 601 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Any Mouse supported this idea  · 
    An error occurred while saving the comment
    Any 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.

Feedback and Knowledge Base