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