View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
L. Howard Kittle[_2_] L. Howard Kittle[_2_] is offline
external usenet poster
 
Posts: 21
Default count how many characters in a cell?

Hi again SS,

Since you posted to a programming group perhaps you wanted a VBA solution.

Sub TheLen()
Dim i As String
i = Len(Range("A1"))
MsgBox i
End Sub

HTH
Regards,
Howard

"SS" wrote in message
...
Is it possible to get one cell to tell me how many characters are in

another
cell (counting spaces as characters)?
ss