Thread: [Solved] How to get the Right function to return a string that has UPPERCASE letters only
View Single Post
 
Old 08-28-2014, 11:24 AM
adj adj is offline Windows 7 64bit Office 2010 64bit
Novice
  
Join Date: Aug 2014
Posts: 5
adj is on a distinguished road
Default How to get the Right function to return a string that has UPPERCASE letters only
How do I format the return string for the Right function to find UPPERCASE letters? For example, I tried the following, [A-Z], which didn't work:

SelectedText = Selection.Text
Right(SelectedText, 2) = "[A-Z][A-Z]"

Thanks
Reply With Quote