Find Uppercase in Excel

[mrichey]

Hello, I'm not a "natural" coder as most of you seem to be. I need to be able to determine if the first 3 charachers of each cell below are uppercase. Is there code that would do this for me? The list is actually quite long, this is a small subset. Thank you!!!

TREAS02-FL-JAX
Internet Explorer
Tivoli DM
Monitoring
TRUST01-FL-JAX
Internet Explorer
Tivoli DM
Monitoring
UPCS-CA-SB
Internet Explorer
Tivoli DM
Monitoring
VRUI_PROD10
Reveille
XVRUI
Tivoli DM
Monitoring
VRUI_PROD12
CEAgent
Internet Information Services
Reveille

 

[PHV]

A starting point:
If UCase(Left(some variable, 3)) <> Left(some variable, 3) Then
MsgBox "Don't pass the criteria"
End If

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[KenWright]

If you didn't want to use code, then assuming your data started in say cell A2, in say B2 use

=SUMPRODUCT(--(CODE(MID(A2,{1,2,3},1))<=90))=3

and then copy down.

Regards
Ken...........

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[PHV]

Ken, are you aware your post is offtopic (we're in VBA forum) ;-)

 

[KenWright]

Yeah, but given the way the question was phrased, I'm guessing that code maybe wasn't a requirement, but more an assumption on the OPs part that it was necessary. Just giving him the option in case that's how it was

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[mrichey]

Thanks Ken! You're exactly right. I didn't need code. Apologies for posting to the wrong board, but much thanks for recognizing my need!

Mark