The proper function incorrectly capitalizes the letter after an apostrophe. Language US-EN 1033
J Josh Ross Jan 27, 2005 #1 The proper function incorrectly capitalizes the letter after an apostrophe. Language US-EN 1033
J JE McGimpsey Jan 27, 2005 #2 Actually, it's correct, if not what most people would want. Then again, XL is not a word processor. As documented in Help:
Actually, it's correct, if not what most people would want. Then again, XL is not a word processor. As documented in Help:
P Peo Sjoblom Jan 27, 2005 #3 One way to trick it would be to use something like =SUBSTITUTE(PROPER(SUBSTITUTE(A1,"'","zzz")),"zzz","'") Regards, Peo Sjoblom
One way to trick it would be to use something like =SUBSTITUTE(PROPER(SUBSTITUTE(A1,"'","zzz")),"zzz","'") Regards, Peo Sjoblom
