Mobile Phones

Hello,

i would like to ask how i can put in a cell mobile numbers like 6972600060; 6909902426
now i have all numbers in cells the one under the other and want to make this automatically because they are many.
Now the mobile numbers are like below

6972600060
6909902426

Thanks in advance

THe question really doesn't make itself very clear!

Where are these numbers coming from and what do you want to do with them? Just insert them into a sheet?

i use an android application to send sms to my cooperators the problem is that when i copy paste the mobile numbers they cannot be sent because they must be in a cell having ; between one another

Sorry, I'm probably being very dense, but are you trying to hook up an android application (I assume a C derivative language?) and an excel spreadsheet?

If so, and I understand, then the following will work (assuming numbers in column A1 -A? and output in B1)

Please Login or Register  to view this content.

Sorry, line 7 should equal:

Please Login or Register  to view this content.