Forum Discussion

aallman's avatar
aallman
Helper II
2 years ago
Solved

Help with If Statement to modify text in query

I am brand new to M language and PowerQuery so I would greatly appreciate a little bit of an explanation along with an answer to this question so that I can learn!   I have a column of text values ...
Need Help
  • amustafa's avatar
    amustafa
    2 years ago

    Hi aallman 

    You can simply right mouse click on the column, select Transform -> Trim to remove the leading and trailing spaces before you do other transformations. This will not remove your N/A values.

     

amustafa's avatar
amustafa
Solution Sage
2 years ago

Hi aallman 

You can simply right mouse click on the column, select Transform -> Trim to remove the leading and trailing spaces before you do other transformations. This will not remove your N/A values.