Error handling

[gtamir]

I have "Mobile" column with some phone numbers containing (-). I change type to txt, and I want to replace the (-) with nothing.

How do I do this?

In the query it won't do it, if I use try expresion  I get the column with the errors and replace the (-), but this column contains only the lines that had errors. I want to put the values back in the original column.

[v-chuncz-msft]

@gtamir,

You may simply select Replace Values from the Home tab in the Query Editor.

[gtamir · Accepted solution]

I understand now. I have to do it in the query and not from the query errors.

[gtamir]

I can't do that in bulk. There are several different errors.