Forum Discussion
Solved
Need to remove numbers from a column
I have a column that has a mix of numbers and text. Example: Column ABC ABC2 123 456 A1B1 I need to remove the ones that have only numbers (123, 456) not the ones that have text and numb...
Use this in a custom column
if Value.FromText([Column1]) is number then null else [Column1]
Manoj_Nair
Solution Supplier
Solution Supplierjj101- Try this
if Text.Regex.IsMatch([Column], "^[0-9]+$") then null else [Column]Let me know if this works.
If this post helps to find solution would be happy if you could mark my post as a solution and give it a thumbs up
Best Regards
Manoj Nair
Linkedin - https://www.linkedin.com/in/manoj-nair-%E2%98%81-344666104/