Hi all! I'm hoping you can help me.
I would like all lowercase/non-capitalized words to be removed from my active sheet (rows 2 to 500), with only capitalized words remaining. Is there a macro/VBA or formula to accomplish this task?
For example: Is Vienna a city in Austria? (in cell B7)
Desired output/result: Is Vienna Austria (in cell B7, the same cell)
Another example: where do John and I go to school? (in cell C5)
Desired output/result: John I (in cell C5)
I hope I am explaining this clearly. Thanks in advance for your help!
I would like all lowercase/non-capitalized words to be removed from my active sheet (rows 2 to 500), with only capitalized words remaining. Is there a macro/VBA or formula to accomplish this task?
For example: Is Vienna a city in Austria? (in cell B7)
Desired output/result: Is Vienna Austria (in cell B7, the same cell)
Another example: where do John and I go to school? (in cell C5)
Desired output/result: John I (in cell C5)
I hope I am explaining this clearly. Thanks in advance for your help!