InvestorsHub Logo
Boards
News
Market Data
Markets
Discover
Discover
AI Subscribe Login/Register account icon
S&P 500
5,408.42
(
-1.73%
)
US TECH 100
17,870.94
(
-3.09%
)
Dow Jones
40,345.41
(
-1.01%
)
Brent Oil
70.89
(
0.00%
)
Bitcoin
54,541.38
(
0.68%
)
Post# of 47256
Next 10
Reply Private New
Public Reply Private Reply New Post
Keep Last Read
Replies (1) Keep Next 10 Report Keyboard Shortcuts
Replies (1) Next 10 Prev Next

RandyH

Send PM Follow Ignore
Followers 1
Posts 19
Boards Moderated 0
Alias Born 03/02/2002

RandyH

Re: Conrad post# 34142

Tuesday, 03/08/2011 2:55:19 AM

Tuesday, March 08, 2011 2:55:19 AM

Post# of 47256
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.
Public Reply Private Reply New Post
Keep Last Read
Replies (1) Keep Last Read Next 10 Report Keyboard Shortcuts
Replies (1) Next 10 Prev Next
Join InvestorsHub

Join the InvestorsHub Community

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.

Sign Up