Forum Discussion
sparvez
Helper I
Helper IVerify if column contains letter
Hello altruists, How to verify in Power Query if certain column contains letters ( from A to Z ) ? Thank you in advance.
Hi sparvez
You can add a custom column with below code.
Text.Length(Text.Select([Column1],{"A".."Z"}))>0If you want it to ignore case, you can use
Text.Length(Text.Select([Column1],{"A".."Z","a".."z"}))>0Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
nickvanmaele
Advocate II
Advocate IIHi,
If you want to check for any letter, you can simply modify my above solution by setting:
listLettersToCheckFor = { "A" .. "Z"}
The solution will work immediately.
Since it has only 3 steps (or even just 2 if you combine them), it is already quite simple.
You could also make a custom function out of the above which returns TRUE or FALSE.