Solved Want to add a number to 2 existing numbers in one cell

September 25, 2012 at 23:06:02
Specs: Windows 7
A1 looks like this 3040, 4040, I want to add +12 to these numbers and show the answer in the next cell with the same format.
IE. 3052, 4052

See More: Want to add a number to 2 existing numbers in one cell

Report •

#1
September 26, 2012 at 06:14:05
✔ Best Answer
=LEFT(A1,4)+12 & ", " & RIGHT(A1,4)+12

Assuming no leading or trailing spaces in A1.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question