Count number of characters in a cell and add number to new column

[digenie]

I need to count the number of characters in the cells in a column and then put this number into a new column - I’m looking for issues in the data in the original column and the only way I can do this cleanly is to search calculate the number of characters into a new column, and then filter on the new column.

e.g.

ID	Char Count
abcd_	5
ab_	3
abcd_	5
abcdefghijk	11
ab_	3
abcd_	5

I have millions of rows and there will likely only be a dozen or so issues, and the character we use “" at the end of our ID can be contained in the IDs we’re looking to highlight, so I can’t just search for "”!

This is probably very easy but I just can’t work it out atm!

[fhs]

Hello,

You can use “Calculate new columns(s)” to do it.

If you want to directly filter, use “Filter by condition”.

If you search fields that contains a character, use function “contains”.

[digenie]

Thank you!

I knew it was there somewhere

What a great community this is.