When using PROPER to capitalise text, how do you get "CAN'T" to become "Can't" instead of "Can'T".
B borobutch Jan 16, 2005 #1 When using PROPER to capitalise text, how do you get "CAN'T" to become "Can't" instead of "Can'T".
B Bob Phillips Jan 16, 2005 #2 How odd! You could just replace it and then replace it back =SUBSTITUTE(PROPER(SUBSTITUTE(A27,"'","QAZ")),"qaz","'") -- HTH RP (remove nothere from the email address if mailing direct)
How odd! You could just replace it and then replace it back =SUBSTITUTE(PROPER(SUBSTITUTE(A27,"'","QAZ")),"qaz","'") -- HTH RP (remove nothere from the email address if mailing direct)
