This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I was wondering if it is possible to filter based on a specific number of characters? I have a product id field in my data and the id's are all 6 digits. There are also some cells in the field though that list out multiple ids in a cell in the following format ( 123456 | 123457 | 123458 | ...). Is it possible for me to filter down to just the cells that contain 6 characters?
The format isn't really an issue. I just wanted to filter out the rows formatted that way because they contain multiple product ids. Your solution would work great if I wanted to separate out the ids in those cells and keep the ones that are 6 characters, but I don't need to. Appreciate the help though!