S
SS
Is it possible to get one cell to tell me how many characters are in another
cell (counting spaces as characters)?
ss
cell (counting spaces as characters)?
ss
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
if data is in A1, use "=len(A1)"
it'll count spaces too.
it'll count spaces too.
C
Cecilkumara Fernando
SS,
Try
=Len(A1)
to count the characters in A1
Cecil
Try
=Len(A1)
to count the characters in A1
Cecil
L
L. Howard Kittle
Hi SS,
LEN(A1)
HTH
Regards,
Howard
LEN(A1)
HTH
Regards,
Howard
L
L. Howard Kittle
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
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
S
SS
thanks.
=len(A1) will do fine.
I posted here 'cos in the past I've got better responses than in other excel
groups.
hope I'm not too off topic.....
If I am then I'm sorry.
SS
=len(A1) will do fine.
I posted here 'cos in the past I've got better responses than in other excel
groups.
hope I'm not too off topic.....
If I am then I'm sorry.
SS