Conrad: It is this part ,"", that gives the problem.
It is probably a result of you cutting and pasting the formula from an incorrect display of those characters. Those should both be normal double-quote symbols. However, some browsers and email clients will incorrectly display them as a left double-quote and a right double-quote.
EXCEL doesn't know what to do with left and right double-quote symbols. It requires the normal double-quote to delimit the string on both sides.
Register for free to join our community of investors and share your ideas. You will also get access to streaming quotes, interactive charts, trades, portfolio, live options flow and more tools.