Home |
Search |
Today's Posts |
#1
|
|||
|
|||
auto count for cells
Is there any way to count the characters in a cell?
I have to only have 12 in one and 30 in another. HELP!! christa |
#2
|
|||
|
|||
The formula is
=LEN(A1) Substitute your actual cell reference for A1. This returns the number of characters in a string. |
#3
|
|||
|
|||
YES!!!! THANK YOU SO MUCH. You just saved me literally hours of work.
"Dave O" wrote: The formula is =LEN(A1) Substitute your actual cell reference for A1. This returns the number of characters in a string. |
#4
|
|||
|
|||
Thanks from me to! So simple and yet saves so much time!
Cheers Jim "Dave O" wrote: The formula is =LEN(A1) Substitute your actual cell reference for A1. This returns the number of characters in a string. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AUTO COUNT IN A CELL WITH EACH TIME USED/ OPENNED | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions |