Excel-Sum with text in cell?? 1

[gdbsti]

Hi all, I did a search here but could not find an answer...
I need a formula to add (+1, or +9) to a cell containing letters and numbers. eg:

A
1 AB1234
2 AB1235
3 AB1236

TIA
Bruce

 

[ilses]

Something along the lines of:

=LEFT(A1;2)+(RIGHT(A1;4)+9)


Ilse

 

[Bowers74]

More like this (assuming all of your data has 4 numbers at the end that you want to add 1 or 9 to:

=Value(right(A1,4))+1 or
=Value(right(A1,4))+9

If you need to have the number "reconnected" to the letters:

=Left(A1,2)&Value(Right(D1,4))+1 or
=Left(A1,2)&Value(Right(D1,4))+9

I hope this helps!




Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[Bowers74]

Ooops,

That should read:

=Left(A1,2)&Value(Right(A1,4))+1 or
=Left(A1,2)&Value(Right(A1,4))+9

For the second formulae!

Sorry!

Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[gdbsti]

Thank you very much Ilse and Mike..
On with the project!

Cheers
Bruce