9 Replies Latest reply: Mar 2, 2016 6:03 PM by Marco Wedel RSS

    Restrict and create new field based on Length

    Jeremy Schmitt

      I'm not sure how to word this, but I have an Excel spreadsheet that contains some account numbers that we need to use for reporting purposes. Because this field is manually entered by multiple agents, the data formatting/length is not uniform and contains an array of text and numbers. 

       

      Without going back and fixing the data, is there a way I can limit and pick out only the entries with 10 or less numbers (These are valid)? I have already removed all alpha characters from the mix, but I have data that looks like the below. Can I use the "LEN" function somehow? Anyone have some suggestions?

       

      Capture.JPG