Can excel round 10 uniqe digits up by 1??

[siyat]

Hi,

I have a liste with 2000 phone numbers and can i make a liste e.g.

A1 45 22 49 58 60

and i want to get in A2: 45 22 50 59 61, A3: 45 22 51 60 62 and etc.

is that possible?

I am very new so i don't know how to write VBA but i know how to use them ....

 

[stefankemp]

In A2: "=LEFT(A1,6)&MID(A1,7,2)+1&" "&MID(A1,10,2)+1&" "&MID(A1,13,2)+1"

Copy this down into A3, A4 etc.

 

[siyat]

Hi Stef,

Thank you for you replay, but i get "erro" when i put it to A2.

It's says "the formula you typed contains an erro"

Do you have any sugestions?

 

[stefankemp]

Did you enter the formula without the two outside quotation marks? In other words in cell A2 you should enter:

=LEFT(A1,6)&MID(A1,7,2)+1&" "&MID(A1,10,2)+1&" "&MID(A1,13,2)+1

 

[siyat]

Yes indeed.
I should say that i use Excel 2007

 

[stefankemp]

hmmm... it works fine for me in Excel 2007. Does your entry in A1 contain any leading spaces perhaps?

 

[siyat]

Ok, when i paste it directley in A3 dosent make anything to happen.
Then i have to put it in that box where you can edit fields then i get an erro on this command
But thank you for this effort you made