Excel 2008 : Formula to remove consecutive capital letters from text strings

Hi JesseG,

If you had VBA behind Excel we might write a VBA Macro that did what you needed. I'd say you would need more than 5000 rows that needed "fixing" before the time would be worth it.