Excel VBA Case Conversion – LCase, UCase, StrConv
Published 2026-03-07 · convertcase.in
When Excel formulas are not enough, VBA macros give you full control over text case conversion. Here's how.
Try it now — free instant conversion
No signup · No limits · Works on all devices
1VBA Functions
LCase("HELLO") → "hello"
UCase("hello") → "HELLO"
StrConv("hello world", vbProperCase) → "Hello World"2Bulk Column Conversion Macro
Sub ConvertToLower()
Dim c As Range
For Each c In Selection
c.Value = LCase(c.Value)
Next c
End SubFrequently Asked Questions
Can I convert case for an entire column in Excel VBA?
Yes — loop through the selection with For Each and apply LCase/UCase to each cell value.