This is a macro that convert values to CamelHumpNotationSub FixCamelHump() ' ' FixCamelHump Macro ' Dim strValue As String Range("A1").Select strValue = ActiveCell.Value Do While strValue <> "" ActiveCell.Value = FixThisString(strValue) ActiveCell.Offset(1, 0).Select strValue = ActiveCell.Value Loop End Sub Private Function FixThisString(strValue As String) Dim intCnt As Integer Dim blnStartOfWord As Boolean Dim strBuild As String Dim strCurrentChar As String For intCnt = 1 To Len(strValue) strCurrentChar = Mid(strValue, intCnt, 1) If IsLetter(strCurrentChar) = True Then If blnStartOfWord = False Then blnStartOfWord = True strBuild = strBuild & UCase(strCurrentChar) Else strBuild = strBuild & LCase(strCurrentChar) End If Else If blnStartOfWord = True Then blnStartOfWord = False End If strBuild = strBuild & strCurrentChar End If Next FixThisString = strBuild End Function Private Function IsLetter(strChar As String) As Boolean If Asc(strChar) >= 97 And Asc(strChar) <= 122 Or Asc(strChar) >= 65 And Asc(strChar) <= 90 Then IsLetter = True Exit Function End If IsLetter = False End Function
Active Directory
AD
Archive
Backup
CircularLogArchiver
CMD
CommandThreader
CopyDHCPClients
Creation Time
DHCP
Domain Controller
Downloads
Drivers
Generate String
GenStr
GetRegionalSettings
GPO
IFPING
KeepDHCPAddress
Logs
Mailbox
MailboxCreationTime
MoveSysvol
Ping
Pingable
proxyAddresses
Recovery Mode
Regional Settings
Script
Scripts
ServerManagerCmd
Service
SetDevicePath
Status
Sysocmgr
SysPrep
Sysvol
Threading
Tiler
Unapproved
WDS
WSUS
WSUS_Cancel_Unapproved_Downloads
WSUS_Cleanup
WSUS_Get_Status Awesome Utilities (1)
Development (12)
Scripts (16)
WP Cumulus Flash tag cloud by Roy Tanck and Luke Morton requires Flash Player 9 or better.
0 Responses
Stay in touch with the conversation, subscribe to the RSS feed for comments on this post.