Extract Proper Case words

Hello All,

I have been using following code to extract all upper case words in a string but the problem is I can not extract words which are proper. For example

This is GOOD

Present output: GOOD
Desired Output: This GOOD

Please Login or Register  to view this content.

Can any one please suggest what can be suitable modification in this case?

Thanks,
Webbug

Example

Please Login or Register  to view this content.

This is great

Originally Posted by jindon

Example

Please Login or Register  to view this content.

Originally Posted by webbug08

This is great

Originally Posted by jindon

Example

Please Login or Register  to view this content.

I know the OP appears to have indicated your function above answered his question, but over in the MrExcel forum (where he cross-posted the question), he posted this in response to one of the proposed functions there...

"This works very well but the only problem is that, the earlier function also
reported the numbers in the string but this is not. Is there any work around it?"

Your function does not seem to filter out numbers; for example, the "word" Tw8o gets through it. While he has not posted back to the MrExcel forum yet, so we do not know if numbers still bother him or not, here is a function that mikerickson and I, in combination, posted which appears to work the way we think the OP wants (at least as indicated over in the MrExcel forum)...

Please Login or Register  to view this content.

What's the issue here?

Do it in MrExcel.

Op accepted the given solution and I will reply to OP, if he asks further adjustment here.

Dear Rick, apologies for multiple post.. I will take care of it in future..

Thanks so much for your valuable post.

Originally Posted by jindon

What's the issue here?

Do it in MrExcel.

I just figured you would want to know given the OP asked the identical question in both forums, but gave some varying feedback in each. I attributed that to the OP's inexperience with forums. Obviously you took offense to my trying to keep you informed on an issue we were both involved with across different forums... sorry for upsetting you and I will make sure I never do that for you again.

Thanks and we better not discuss the matter as an inter-forum conversation.

Only OP knows what he wants to ask.