Couldn't convert to number due to symbols, find and replace doesn't work

[victoria_g06]

Hi All, 

I have this DataFormat.Error because of the symbols around the number. 

I've tried to change to text and use replace values for each of the symbols but it doesn't do anything. 

Has anyone else come across this problem? 

[lbendlin]

Note that the split function supports custom logic, including the transition between numbers and non-numbers.

[Fowmy]

@victoria_g06 

Please share some sample data where you have this symbols included. you can paste it in your reply.

[victoria_g06 · Accepted solution]

Hi Fowmy, thanks for the reply, I've spent all day looking for answers and then when I ask for help suddenly it works.

I had a custom function to expand tables that had a change type inside, so I removed the change type and then I could remove the symbols.