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
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