Preperly Apostrophised?

Posted by Andy Gee on January 11, 2002 6:37 AM

I have a formula =PROPER(A2) in A1 and A2 contains the text "I'm trying" But the resilt is I'M Trying. I would like it to read "I'm Trying".

Note. The Apostrophy can be in any location except the first and list character.

Andy help would be a dream!

Posted by Chris D on January 11, 2002 6:51 AM

Have a shifty at

Tools
Autocorrect

I think you can set your own exceptions

Posted by Aladin Akyurek on January 11, 2002 6:56 AM

Andy --

I think you've discovered a "bug", which is hard to cope with a general algorithm for PROPER'ing.

Try the following workaround:

=SUBSTITUTE(PROPER(SUBSTITUTE(A2,"'","aaaaaaaaaaaaaaaaaaaaaaaaaaa")),"aaaaaaaaaaaaaaaaaaaaaaaaaaa","'")

Aladin

=========

Posted by Andy Gee on January 11, 2002 7:01 AM

Re: Need a find and replace I think

Doesn't work with ' any other ideas

Posted by Andy Gee on January 11, 2002 7:08 AM

I'm not sure how it works! but it does!

I'm not sure how it works! but it does!
Thanks

Posted by Chris D on January 11, 2002 7:11 AM

Re: Need a find and replace I think

Aladin's works !

I should test before I post

sorry about that mate

Posted by Andy Gee on January 11, 2002 7:19 AM

Re: No probs!

I should test before I post sorry about that mate

No problems, I hevent used the autocorrect for ages, forgot it existed! Thanks for reminding me!