Filter a column on number of characters

[BPTBPTBPT]

Hello all,

I have a column with numbers. All numbers should be 6 digits long. However, some contain more, some less. 

I figured out how to eliminate those with more than 6 numbers: by splitting the column. But how to eliminate those with less?

Can I use a filter? Do I need a new column? Any help would be appreciated. Thanks.

[BPTBPTBPT]

This worked, thanks!

[NickolajJessen · Accepted solution]

Use Text.Length in Power Query to find length and sort away all who are not 6 🙂