| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Counting indvidual digits
-- James Bonds Excel Learner |
|
#2
|
|||
|
|||
|
You didn't give much to go on, but perhaps something like:
=LEN(SUBSTITUTE(SUBSTITUTE(A1,"-",""),".","")) In article , "James" wrote: |
|
#3
|
|||
|
|||
|
See next post above.
-- James Bonds Excel Learner "JE McGimpsey" wrote: You didn't give much to go on, but perhaps something like: =LEN(SUBSTITUTE(SUBSTITUTE(A1,"-",""),".","")) In article , "James" wrote: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting... | Excel Worksheet Functions | |||
| Sort by last 2 digits | Excel Worksheet Functions | |||
| Least number of digits in Y-axis labels | Charts and Charting in Excel | |||
| How do I format cells to a specific number of digits? | Excel Discussion (Misc queries) | |||
| Using a IF formula, I would like to drop the 2 digits in front of. | Excel Discussion (Misc queries) | |||
Linear Mode
