Replace in Excel table range

hi all,
i am trying do a replace function to remove # in column C & USD in column D. I used a table range. There was no error but the replace wasn’t completed. What have i went wrong?

Hi @Kinalina, I think you should use a text action to remove characters in this case

Thanks, I tried. It’s working. I have another problem, when I got a list of price from web, say USD$0.00. I used replace text to remove USD but when i tried with a second replace action to replace any $0.00 to $100, it gave an error. what other action can i use?

What error do you get?