#VALUE error when using MID

[lmcc007]

To get the numbers in separate cells, I am using the below code:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Sometimes Column E has only one number instead of two. When that happens, it is putting a space.

Then I tell it to add F3 + G3, but I get an error message whenever there is one number instead of two numbers in Column E.

Please Login or Register  to view this content.

Error message: #VALUE!

To get rid of the error, I have to manually delete the space.

Is there a better way of doing this?

[KOKOSEK]

You want to get seconds digit from 1 digit number.
As I see you wants to get 1st and 2nd digits, so you sure that numbers are <100.
So i suggest instead of MID use LEFT and RIGHT.

F2:

Please Login or Register  to view this content.

G2:

Please Login or Register  to view this content.

drag both down and results in column H are fine.

[jeffreybrown]

How about =IFERROR($F2+$G2,"")

[mjr veverka]

?
F2 = choose(len($e2),$e2,left($e2,1))
g2 = choose(len($e2),0,right($e2,1))
?

[lmcc007]

KOKOSEK,

Thanks! It is working!

[lmcc007]

How about =IFERROR($F2+$G2,"")

No, this is not what I want. I don't want to ignore the error. Thanks.

[lmcc007]

porucha vevrku,

This works also! Thank you!

[jeffreybrown]

Error message: #VALUE!

To get rid of the error, I have to manually delete the space.

Is there a better way of doing this?

Glad you found what you were seeking, but with your quote above, how was I to know you don't want to ignore the error.

Also, please don't full quote everybody that responds.