Forum Discussion

Anthea's avatar
Anthea
Frequent Visitor
8 years ago
Solved

how to remove punctuation within a column

Hello   Does anybody know if punctuation can be removed from numbers in a column (the data type is set as 'Any' as there are also lots of words in the column)? I currently have a relationship set u...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    In Power Query, right-click the column and choose "Replace Values".

  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Anthea,

     

    In Query Editor mode, right click the column which contains punctuation ".", choose "Replace values".

     

    Best regards,

    Yuliana Gu

Anthea's avatar
Anthea
Frequent Visitor
8 years ago

Thanks, how do I do this?

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

In Power Query, right-click the column and choose "Replace Values".