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.