how to remove punctuation within a column

[Anthea]

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 up with a file containing the part numbers that are in this column that are without a '.' so I am looking to remove the '.' on my source file so that the 2 files recognise the same data (like Find/Replace in Excel)

Many thanks

[Greg_Deckler · Accepted solution]

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

[v-yulgu-msft · Accepted solution]

Hi @Anthea,

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

Best regards,

Yuliana Gu

[Greg_Deckler]

Yes, in Power Query you can do a replace of anything with blank.

[Anthea]

Thanks, how do I do this?

[Greg_Deckler · Accepted solution]

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