2010 Functions Don't Work

[PaulPCoker]

This a weird problem, which started when I installed Office 2010.



I am a very experience Excel user. I have made none of the errors listed in Excel Help. In fact, I have even used the insert function wizard, in case Office 2010 uses a different syntax from older Excel versions. The wizard correctly echos the values of the chosen arguments, but fails to show a function result for those functions that don't work. Excel gives me an error message and refuses to accept the function, for those that don't work. Often it says not enough arguments were entered, when all the right ones *were* entered (remember, using function wizard).


These text functions work: CHAR(123), CLEAN(C4), CODE(C5), DOLLAR(D5), FIXED(D5), LEFT(C8), LEN(title), LOWER(C10), PROPER(D10), T(C12), TRIM(C13), UPPER(C14)
These do not: CONCATENATE(A6 " " B6), EXACT(A7 B7), FIND(A7 B7), FIXED(D5) {works only if *all* optional arguments are omitted, so will only return number with 2 decimals and no commas.}, LEFT(C8) {works only if optional argument is omitted, so will only return 1 character.}, MID(C11 5 8), REPLACE(C12 5 8 F3), REPT(A12 5), RIGHT(C12) {works only if optional argument is omitted, so will only return 1 character.}, SEARCH(F3 C12 2), SUBSTITUTE(C12 F3 B6 1), TEXT(D7 "$0.00")


Any idea what might be wrong? I have reloaded office several times.

[PaulPCoker]

Someone suggested using commas:
"1/ =CONCATENATE(A6," ",B6) 2/ =EXACT(A7,B7) 3/ =FIND("Text",B7) etc"
"Use the comma between the comma in the functions to separate the arguments etc!"

Thank you for trying to help, but I have tried this. It works the same as
without commas (i.e. doesn't work), although the error message is then
less likely to accuse me of too few arguments, just saying that there is an
error in the formula. Remember that I used the function insert wizard
specifically to be sure something like this wasn't the issue.

I ran my computer in "Safe" mode, and tried to reproduce the issue. Then Office
won't even start, accusing me of "Multiple ARP entries found for product"; except
that Office 2010 was loaded on a brand new computer from an unopened package
purchased at BestBuy with the computer. There should be no license problems!

[Pecoflyer]

Perhaps your regional settings need a semi colon like =left(a1;2) ?

[PaulPCoker]

That's a good thought, but I just tried it. Excel won't even let me finish typing it before it declares an error. Clearly it *wants* either a space or a comma as a separator, and it recognizes the arguments as distinct arguments if I use either of those syntax (which I can tell from the way the wizard is acting), but then it refuses to accept the resulting function for some reason.

I tried running Excel in safe mode, then Windows in safe mode, because of suggestions I saw in other people's threads. The first made no difference, but the second wouldn't even let me boot Excel; gave me a setup error of "Multiple ARP entries found for product".

Microsoft Excel 2010 (14.0.6117.5003) SP1 MSO (14.0.6123.5001)
Part of Microsoft Office Home and Business 2010
This product is licensed to: Hewlett-Packard
Product ID: 01631-237-4701036-11266

OS Name Microsoft Windows 7 Home Premium
Version 6.1.7601 Service Pack 1 Build 7601
System Manufacturer Hewlett-Packard
System Model HP Pavilion dv6 Notebook PC
System Type x64-based PC
Processor AMD A8-3500M APU with Radeon(tm) HD Graphics, 1500 Mhz, 4 Core(s), 4 Logical Processor(s)
BIOS Version/Date Hewlett-Packard F.1C, 5/12/2011
SMBIOS Version 2.7
System Directory C:\Windows\system32
Hardware Abstraction Layer Version = "6.1.7601.17514"
Installed Physical Memory (RAM) 6.00 GB

[Pecoflyer]

Perhaps reinstall MSOffice?