Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting the number of characters in a cell
Is there a formula that will tell me how many character are in a
cell. For example cell 1 Happy it will return 5 cell 2 Happy Birthday it will return 14 I need to include spaces in the count. Thanks in advance for your help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting the number of characters in a cell
=LEN(A1)
-- Regards, Peo Sjoblom wrote in message ... Is there a formula that will tell me how many character are in a cell. For example cell 1 Happy it will return 5 cell 2 Happy Birthday it will return 14 I need to include spaces in the count. Thanks in advance for your help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting the number of characters in a cell
On Dec 18, 4:11 pm, wrote:
Is there a formula that will tell me how many character are in a cell. For example cell 1 Happy it will return 5 cell 2 Happy Birthday it will return 14 I need to include spaces in the count. Thanks in advance for your help. =LEN(A1) etc. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting the number of characters in a cell
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting the number of characters in a cell
On Dec 18, 4:15 pm, Dave F wrote:
On Dec 18, 4:11 pm, wrote: Is there a formula that will tell me how many character are in a cell. For example cell 1 Happy it will return 5 cell 2 Happy Birthday it will return 14 I need to include spaces in the count. Thanks in advance for your help. =LEN(A1) etc. Thanks it worked! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting number of characters? | New Users to Excel | |||
Counting the number of specified text characters within a cell | Excel Worksheet Functions | |||
counting characters in a cell | Excel Discussion (Misc queries) | |||
counting characters inside a cell | Excel Discussion (Misc queries) | |||
Counting Characters in a Cell | Excel Worksheet Functions |