 |
 |
 |
 |
| Excel UCase - LCase Function |
|
Excel UCase / LCase Functions
This is another useful set of functions here at Excel help. It is important to remember that the UCase function is used to convert text to ‘Upper Case’ and likewise, LCase is used to convert text to ‘Lower Case’.
The basics:
Now let’s look at an example. Let’s assume we want to process a group of data converting it to both upper and lower case characters. This is our unprocessed data.
Code
Dim StringToProcess As String 'The variable that will contain the string to be evaluated Dim A As Long 'The counter we will be using the process our records
For A = 2 To 8 'In this example we only want to process 7 rows
StringToProcess = ActiveSheet.Cells(A, 1).Value 'We want to process all the values in the first column of the active worksheet. For our 'example we have fixed the column value at 1 (so it is static) and allow the row value to change 'as we process the records.
ActiveSheet.Cells(A, 2).Value = UCase(StringToProcess) ActiveSheet.Cells(A, 3).Value = LCase(StringToProcess)
Next
|
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation.
Copyright 2011 ExcelHelp.com All rights reserved
More Info (+)