Forum Discussion
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 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
In Power Query, right-click the column and choose "Replace Values".
Hi Anthea,
In Query Editor mode, right click the column which contains punctuation ".", choose "Replace values".
Best regards,
Yuliana Gu
4 Replies
Yes, in Power Query you can do a replace of anything with blank.
Thanks, how do I do this?
In Power Query, right-click the column and choose "Replace Values".
Hi Anthea,
In Query Editor mode, right click the column which contains punctuation ".", choose "Replace values".
Best regards,
Yuliana Gu
