How to get the Right function to return a string that has UPPERCASE letters only

gmayor · #6 08-29-2014, 09:32 PM

Quote:

Originally Posted by adj

I've tried a couple of different major approaches (one approach is Find; 2nd approach is to have the macro look at each word). I'm going to try to figure out which approach is best (or whether a combo is necessary) ........ the Right function is any UPPERCASE letter--i.e., what to use between the quotes (after the '=' sign) in the Right function.

I don't see how processing by word is going to help. It still has the same basic issue that there are two disparate data sequence type BC-3, ABC-5, BC-003 and DA-378-A, which will require separate processes.

Also processing sequentially in this manner is very slow compared with FIND.

One way to check whether the Right string value is upper case is to compare the upper case version with the actual value e.g.

If Right(strText, 1) = Right(UCase(strText), 1) Then
MsgBox "Upper Case"
Else
MsgBox "Lower case"
End If

As Paul also has asked, what are you going to do with the strings found?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Uppercase formula?	clements55	Excel	1	08-20-2014 11:34 PM
Way to search for a string in text file, pull out everything until another string?	omahadivision	Excel Programming	12	11-23-2013 12:10 PM
Can I use the filter function to separate letters into separate files?	drhauser	Mail Merge	2	12-14-2011 02:18 PM
Day and Month to Uppercase	Andy2011	Word VBA	1	07-22-2011 04:34 PM
Macro or Function to know wether a string is included in a text	Eduardo	Word VBA	5	06-15-2009 01:55 AM