Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
count how many characters in a cell?
Is it possible to get one cell to tell me how many characters are in another
cell (counting spaces as characters)? ss |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
count how many characters in a cell?
if data is in A1, use "=len(A1)"
it'll count spaces too. -----Original Message----- Is it possible to get one cell to tell me how many characters are in another cell (counting spaces as characters)? ss . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
count how many characters in a cell?
SS,
Try =Len(A1) to count the characters in A1 Cecil "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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
count how many characters in a cell?
Hi SS,
LEN(A1) 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
count how many characters in a cell?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Text Characters in cell | Excel Discussion (Misc queries) | |||
How do I count the Characters in a cell | Excel Discussion (Misc queries) | |||
Count Characters in A Cell | Excel Discussion (Misc queries) | |||
Count Characters in a cell | Excel Discussion (Misc queries) | |||
How can I count the number of characters on a cell? | Excel Discussion (Misc queries) |