Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Check if character is upper or lower case

Status
Not open for further replies.
emikoo

emikoo

Technical User
Jul 12, 2002
37
0
0
NL
Hello,

I want to check if a character in a certain cell is upper or lower case. For example "A" returns "Upper", "a" returns "Lower".

Thnxs in advance,

EK
 
Sort by date Sort by votes
=code(cell_address) will give you 65 if the first letter in the cell is A or 97 if it's a.
 
Upvote 0 Downvote
To build on that...

=IF(ISERROR(CODE(A1)),&quot;&quot;,IF(OR(CODE(A1)<65,CODE(A1)>122),&quot;Non Alpha&quot;,IF(AND(CODE(A1)>=65,CODE(A1)<=90),&quot;Upper&quot;,&quot;Lower&quot;)))
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

cneill
  • Locked
  • Question
Combining If and Iferror and Index/Match with Hyperlink
Replies
18
Views
190
cneill
cneill
AndyBellers
  • Locked
  • Question
Regarding: thread68-1090780 If y
Replies
0
Views
40
AndyBellers
AndyBellers
Cpreston
  • Locked
  • Question
If cell is blank use data from another cell 1
Replies
10
Views
90
Andrzejek
Andrzejek
GPnew
  • Question
Power Pivot Filter out Rows where data is not in all columns
Replies
14
Views
264
combo
combo
jlr123
  • Locked
  • Question
Highlight (any) first text word that is a duplicate
Replies
2
Views
122
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top