Replace in Excel table range

excel

#1

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?
replace1replace2


#2

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


#3

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?


#4

What error do you get?