| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting & Displaying
I would like to count the number of characters in a given cell and then be
able to have a display "in your face" telling you how many characters you have remaining for the particular cell. In my case, I have a total of 6 COMMENT-type cells. The first one has a validation max of 250 characters and the other five have a max of 150 available. Having looked over previous inquiries, I can find out how to count 'words', but none refer to counting characters. In advance, thanks! Jeff Hennessey |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting & Displaying
You should be able to right a formula like
Assuming data is in cell A1 =250-LEN(A1) LEN gives you the amount of characters in a cell "Henn9660" wrote: I would like to count the number of characters in a given cell and then be able to have a display "in your face" telling you how many characters you have remaining for the particular cell. In my case, I have a total of 6 COMMENT-type cells. The first one has a validation max of 250 characters and the other five have a max of 150 available. Having looked over previous inquiries, I can find out how to count 'words', but none refer to counting characters. In advance, thanks! Jeff Hennessey |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting & Displaying
I'll give it a try! Many THANKS for the quick response. Jeff
"akphidelt" wrote: You should be able to right a formula like Assuming data is in cell A1 =250-LEN(A1) LEN gives you the amount of characters in a cell "Henn9660" wrote: I would like to count the number of characters in a given cell and then be able to have a display "in your face" telling you how many characters you have remaining for the particular cell. In my case, I have a total of 6 COMMENT-type cells. The first one has a validation max of 250 characters and the other five have a max of 150 available. Having looked over previous inquiries, I can find out how to count 'words', but none refer to counting characters. In advance, thanks! Jeff Hennessey |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting & Displaying
=250-len(A1)
"Henn9660" wrote in message ... I would like to count the number of characters in a given cell and then be able to have a display "in your face" telling you how many characters you have remaining for the particular cell. In my case, I have a total of 6 COMMENT-type cells. The first one has a validation max of 250 characters and the other five have a max of 150 available. Having looked over previous inquiries, I can find out how to count 'words', but none refer to counting characters. In advance, thanks! Jeff Hennessey |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting & Displaying
Thanks Gaurav..... Jeff
"Gaurav" wrote: =250-len(A1) "Henn9660" wrote in message ... I would like to count the number of characters in a given cell and then be able to have a display "in your face" telling you how many characters you have remaining for the particular cell. In my case, I have a total of 6 COMMENT-type cells. The first one has a validation max of 250 characters and the other five have a max of 150 available. Having looked over previous inquiries, I can find out how to count 'words', but none refer to counting characters. In advance, thanks! Jeff Hennessey |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting function but not double counting duplicates | Excel Worksheet Functions | |||
| Not displaying a value | Excel Discussion (Misc queries) | |||
| Counting occurences and displaying in a different sheet | Excel Worksheet Functions | |||
| Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
| Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) | |||
Linear Mode
