ExcelBanter - Problem using 'PROPER' with apostrophes

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Problem using 'PROPER' with apostrophes (https://www.excelbanter.com/excel-worksheet-functions/9297-problem-using-proper-apostrophes.html)

borobutch

Problem using 'PROPER' with apostrophes

When using PROPER to capitalise text, how do you get "CAN'T" to become
"Can't" instead of "Can'T".

Bob Phillips

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)

"borobutch" wrote in message
...
When using PROPER to capitalise text, how do you get "CAN'T" to become
"Can't" instead of "Can'T".

All times are GMT +1. The time now is 02:49 AM.