Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Removing unexpected text from a column

Hello, I have a column which contains a number of different word values that repeat numerous times down the column.  Sometimes there's instances where the these words have extra text at the end...
Need Help
  • JoeBarry's avatar
    JoeBarry
    2 years ago

    Hi Anonymous 

     

    Why not try a custom column 

    if Text.Contains([Status], "Backlog") then "Backlog else
if Text.Contains([Status], "Archived") then "Archived" else [Status]

     

    Thanks

    Joe

    If this post helps, then please Accept it as the solution

     

mussaenda's avatar
mussaenda
Community Champion
2 years ago

Hi Anonymous 

How are we going to know your standard words? are they only 2 words --Backlog and Archived?