asked on
Excel PROPER Exclusions
I would like the ability to exclude or ignore certain suffixes or phrases from the PROPER function. For example, if I apply this function to WILSON III, it will be converted to Wilson Iii. Obviously, in this situation, I would like to exclude the suffix. Is this possible?
Office ProductivitySpreadsheetsMicrosoft Excel
Last Comment
Martin Liss
The only way I could see to do this would be create a list of exceptions and then use a formula to look up if the exception applies. In reality this would be almost impossible to implement as the number exceptions would be huge. Personally I think it would be easier to correct these manually or ignore them.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
I've requested that this question be closed as follows:
Accepted answer: 250 points for Patrick Matthews's comment #a40451145
Assisted answer: 250 points for Michael74's comment #a40448964
for the following reason:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Accepted answer: 250 points for Patrick Matthews's comment #a40451145
Assisted answer: 250 points for Michael74's comment #a40448964
for the following reason:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.