Capital & Small Letters
CAn any one give me code for identifing whether data in a cell i capital letter or small case? thanks in advance with regards Excel Powe -- ExcelPowe ----------------------------------------------------------------------- ExcelPower's Profile: http://www.excelforum.com/member.php...fo&userid=3096 View this thread: http://www.excelforum.com/showthread.php?threadid=51678 |
Capital & Small Letters
ExcelPower,
Dim MyString As String MyString = ActiveCell.Value Select Case True Case MyString = UCase(MyString) MsgBox "All capitals" Case MyString = LCase(MyString) MsgBox "No capitals" Case Else MsgBox "Mixed case" End Select NickHK "ExcelPower" wrote in message ... CAn any one give me code for identifing whether data in a cell is capital letter or small case? thanks in advance with regards Excel Power -- ExcelPower ------------------------------------------------------------------------ ExcelPower's Profile: http://www.excelforum.com/member.php...o&userid=30964 View this thread: http://www.excelforum.com/showthread...hreadid=516786 |
Capital & Small Letters
=If(EXACT(a1,UPPER(a1),"UpperCase",
If(EXACT(a1,LOWER(a1),"Lowercase","MixedCase)) or more elaborate =IF(ISBLANK(A1),"B",IF(ISNUMBER(A1),"N",IF(ISERROR (A1),"E",IF(EXACT(A1,U PPER(A1)),"U",IF(EXACT(A1,LOWER(A1)),"L","M"))))) -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam ExcelPower wrote in <news:<ExcelPower.23vjqy_1141020901.0377@excelforu m-nospam.com CAn any one give me code for identifing whether data in a cell is capital letter or small case? thanks in advance with regards Excel Power |
All times are GMT +1. The time now is 09:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com