VB question

[epihammer]

What I want seems so simple but yet I can't seem to figure it out.

In cell A7 I enter the following: 141934a
In cell D7 I want the following result: 141954
It would even be ok if the result came out 141954a

I tried the following: "=A7+20"
Because of the "a" in 141934a it doesn't work.

Is it even possible to get the results I am asking for?

Thanks,
Epihammer

 

[al_b_cnu]

Hi

Try =LEFT(A7,LEN(A7)-1)+20

 

[brian.wethington]

Will you always have one letter?

 

[epihammer]

I tried the above formula and it did work.

Thanks a Million,
epihammer