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

With VBA a simple UDF should work:

Function CleanCapsAndNumbers(rngCheck As Range) As String
   Dim RegExp            As Object
   Dim strInput As String
   Dim strPattern As String
   Set RegExp = CreateObject("vbscript.regexp")
   strInput = rngCheck.Value
   strPattern = "([A-Z][A-Z]+|\d)"
   With RegExp
      .Global = True
      .Pattern = strPattern
      CleanCapsAndNumbers = Application.Trim(.Replace(strInput, ""))
   End With
End Function

Thanks for your help!! I really appreciate it.
Not to push my luck... but if either of you have any bright ideas about how to make this work across languages with different characters (e.g. Chinese, Arabic, Greek, etc.), let me know!
You guys rock!

PS. Re: MarvinP, definitely worth it -- I need to fill out about 40,000 rows for at least 29 different languages, for a total of something like 1,160,000 rows total.