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]
Use this in a custom column
if Value.FromText([Column1]) is number then null else [Column1]
Vijay_A_Verma thank you this worked lilke a charm!