how do i count the number of characters in a cell

so if cell A1 has the day = to "05"....how do i know that there are 2
characters in the cell?

thank you

=len(A1)

"dstiefe" <(E-Mail Removed)> wrote in message
news:1A160E95-4643-485C-A48D-(E-Mail Removed)...
> how do i count the number of characters in a cell
>
> so if cell A1 has the day = to "05"....how do i know that there are 2
> characters in the cell?
>
> thank you

how do you do it in VBA?

"PCLIVE" wrote:

> =len(A1)
>
> "dstiefe" <(E-Mail Removed)> wrote in message
> news:1A160E95-4643-485C-A48D-(E-Mail Removed)...
> > how do i count the number of characters in a cell
> >
> > so if cell A1 has the day = to "05"....how do i know that there are 2
> > characters in the cell?
> >
> > thank you
>
>
>

basically the same way

Sub test()
Dim numChars As Long
numChars = Len(Worksheets("Sheet1").Range("A1"))
MsgBox numChars
End Sub


--


Gary


"dstiefe" <(E-Mail Removed)> wrote in message
news:FEAA52DC-D370-43E6-87D5-(E-Mail Removed)...
> how do you do it in VBA?
>
> "PCLIVE" wrote:
>
>> =len(A1)
>>
>> "dstiefe" <(E-Mail Removed)> wrote in message
>> news:1A160E95-4643-485C-A48D-(E-Mail Removed)...
>> > how do i count the number of characters in a cell
>> >
>> > so if cell A1 has the day = to "05"....how do i know that there are 2
>> > characters in the cell?
>> >
>> > thank you
>>
>>
>>