Thread: Proper() function handling of apostrophe
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Valpey Valpey is offline
external usenet poster
  
Posts: 1
Default Proper() function handling of apostrophe
The Proper() function incorrectly handles possessive apostrophes. (e.g.
Proper(STEVE'S BAR AND GRILL) returns "Steve'S Bar And Grill". Is there a
simple way to return "Steve's Bar And Grill"; or even better "Steve's Bar and
Grill"?
Reply With QuoteReply With Quote