| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
See if this works for you: =LEN(A1)-SUMPRODUCT(LEN(A1)-LEN(SUBSTITUTE(A1,{0,1,2,3,4,5,6,7,8,9},""))) It should accommodate any combination of text and numbers. Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=375769 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy a number from one cell to another depending on first number | Excel Worksheet Functions | |||
| how to stop repeating a number in worksheet(e.g. cell A1 is 6655 . | Excel Discussion (Misc queries) | |||
| Equation Referencing Row Number Stored in Cell | Excel Discussion (Misc queries) | |||
| excel - numbers as text | New Users to Excel | |||
| #VALUE in cell but pop up function box show right number | Excel Discussion (Misc queries) | |||
Hybrid Mode
