Dear Richard,
I would like to define a variable that refers to the first 3 characters of a specific cell.
Example: If the cell data is "January", the variable should be equal to "Jan"
I have the following chunk of code. How can I finish it/correct it?

Dim month as Character
month=Workbooks("Book1.xls").Worksheets("Sheet1").Range("B3")

Thank you very much in advance.
Cheers
Marta

---

Answer from Richard Rost:

If you want to look at a cell that contains "January" and want to return the first three characters "Jan" then just use the LEFT function:

=LEFT(A1,3)

It will also work in your VBA code too.