I found a formula to extract prices from a list, but everytime it doesnt match a variable, it returns an error. I basically need to remove the cells with errors & replace them with the next correctly extracted variable.
Formula using "=MID(A3,FIND("$",A3)+1,8)"
So basically from
9,190.89 #VALUE! 9,176.61 #VALUE! 9000
To
9,190.89 9,176.61 9000
Thanks.
Bookmarks