Thanks:  0
Likes:  0

# Thread: How can excel tell that 59 is 50 and 9 (I need to act on the

1. Assume a1 value is 59. I need to determine that the number is 50 and 9. Then I will do something using the 50 and then something using the 9... It will always be a two digit number (01 through 59). Thanks

2. What you could say is, if A1 = 59, then

=LEFT(A1)*10 will give you 50
=RIGHT(A1) will give you 9.

Rgds
AJ

[ This Message was edited by: AJ on 2002-03-23 08:37 ]

3. Great Aj just did a search and found the left and right but appreciate your help also. I didnt thing about the a1 * 10 for the 50 part.. tks once again

4. Hi,

First digit
=LEFT(Range,1)*10

Last digit
=RIGHT(Range,1)+0

I assume that you handle the leading zeros already. The LEN of the cell value would need to be checked if not.

The +0 forces Excel to treat the value as a number, which it wouldn't if the argument cell was text.

Regards,
Jay

5. On 2002-03-23 08:37, AJ wrote:
What you could say is, if A1 = 59, then

=LEFT(A1)*10 will give you 50
=RIGHT(A1) will give you 9.

Rgds
AJ

[ This Message was edited by: AJ on 2002-03-23 08:37 ]
A bit simpler:

=LEFT(A1,2)+0
=RIGHT(A1)+0

to turn the left and right bits into numbers.

Following up on this thread, rpwagner wants to see the place 10-digit 5 as 50, so your first line would be:

=(LEFT(A1)+0)*10, and the 0-place digit then
=RIGHT(A1)+0

7. Actually, this works

=LEFT(A1)*10
=RIGHT(A1)+0

The '+0' is just an example math operation, therefor, there's no need to '+0' and then '*10' to get a real number

8. You state that information is numbers.
If they are not text, consider the following:

59 in F2 =INT(F2/10) gives 5

and =MOD(F2,10) gives 9

9. On 2002-03-23 08:57, Yogi Anand wrote:
Following up on this thread, rpwagner wants to see the place 10-digit 5 as 50, so your first line would be:

=(LEFT(A1)+0)*10, and the 0-place digit then
=RIGHT(A1)+0
I see I misread rpwagner's query:

=LEFT(A1)*10 is just right.

10. Thanks Juan:
You are right -- there is no need to add that 0, even if the original entry was a text entry!

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•