String

String is a date type. Words are stored in String type data, like "Hello" "John Micheal Cane" "I like the pizza". We will see how to use this String data type.

We have some String datas in the range A1 to A7,

Sub TestForEach()
Dim HumanName As String

HumanName = Range("A1").Value
Range("A1").Offset(, 1).Value = LCase(HumanName)
Range("A1").Offset(, 2).Value = UCase(HumanName)

End Sub

This makes the name John Dow Upper case and Lower case.