Dreamdweller
New Member
- Joined
- Apr 20, 2012
- Messages
- 12
I'm trying to add to a stem and leaf formula that I have. Problem is that I have to use different cells for values. The values have to be either 2, 3, or 4 numbers. I can't use something like 23 in the same range as 123 or in 1234 since the code I am writing only works for 2,3, or 4 digits. So I'm going to try and alter it but I need to know if there is a formula to search whether a cell has 2, 3, or 4 digits in it.
So basically the code would look something like this:
If cell A1 has 2 digits (NOT 2 values) THEN ...
If cell A1 has 3 digits THEN...
If cell A1 has 4 digits THEN...
I'll add the rest of what I think will work but I just need to have something to count how many digits each cell contains.
So basically the code would look something like this:
If cell A1 has 2 digits (NOT 2 values) THEN ...
If cell A1 has 3 digits THEN...
If cell A1 has 4 digits THEN...
I'll add the rest of what I think will work but I just need to have something to count how many digits each cell contains.