MS EXCEL COMMA PROBLEM

[My Heaven]

Dear dosto Umeed hai sab thek honge.
Ms Excel ki thori c help chahye. bohot thaak gya hun i think 47000 number hain.

for example
Question No 1
excel me ye har cell me numbers add hain
IS Tarha!!
98097423
79803450
76783487
59873452
76098734
57690876
98324789
69345789
74368979
48769872
67864937
89776289
34650934
79768934
69873468
94768973
In numbers ko ek hi line(Cell) me add karun
for example is tarha

98097423798034507678348759873452760987345769087698 32478969345789743689794876987267864937897762893465 0934797689346987346894768973

Question No 2
phir in number ko is tarha har 11 digit k baad comma dena chahta hun
For Example

98097423798,03884567678,34875987345,27609873457,69087698324,78969345789,74368979487,69872678649,37897762893,46509347976,89346987346,89476897334

bus ye 2 questions hain plz kindly jaldi help karen.
2 din se comma hi add kar raha hun plz help kar do koi.

[The Genius]

File attach kro main kar deta hoon

[My Heaven]

File attach kro main kar deta hoon

yar us me mobile numbers han attach nhi kr skta. ap procedure bta do

[The Genius]

yar us me mobile numbers han attach nhi kr skta. ap procedure bta do

Agar programming aati he to macro bana lo. Agar nhin aati to manual he karna pre ga.

[My Heaven]

Agar programming aati he to macro bana lo. Agar nhin aati to manual he karna pre ga.

manual to 2 din se kar raha hun . thhak gya hun. koi procedure bta do

[The Genius]

manual to 2 din se kar raha hun . thhak gya hun. koi procedure bta do

Manual karne wala kaam nhin he ye. Aik be coma ghalat lag gya to aage poori line main comas ghalat lagain ge.
File mujhe PM kar do to main kar don ga. Main isse excel se bahar code likh kar karon ga aur phir result ko excel main paste kar doon ha

[My Heaven]

Manual karne wala kaam nhin he ye. Aik be coma ghalat lag gya to aage poori line main comas ghalat lagain ge.
File mujhe PM kar do to main kar don ga. Main isse excel se bahar code likh kar karon ga aur phir result ko excel main paste kar doon ha

ap yahan guide kardo

[My Heaven]

YAR KOI REPLY KARO

[syar]

Pahly ka asan hal ya ha k

1. Adjacent cell ya jahan aap result chahte hain wahan p
2. =CONCATENATE( " lekhain"
3. phir is k bad TRANSPOSE( ka function start karain. aur apne pore data ki range lain.
tu formula kuch yon ho ga

=CONCATENATE(TRANSPOSE('yourrange'))

4. Enter krne sa pahly Transpose k pore function ko Mouse se select Karain aur F9 press karain. aap notice karainge k transpose k function ki jaga aap ko result nazar aai ga. aur us k gird {} brackets honge. aap in Bracket ko delete kar dain. aur enter Press karian. Aap ka Join krne ka masla hal ho jae ga.
But remember k ya as text cell m store ho ga.

Jahan tak aap k comma ka masla ha, us m masla ya ha k aik cell m kiten length aai gi mjy andaza nahee ha. k excel ka aik cell itna lamba digit support kare ga.

Pahly ise try karain phr dosra masla solve krne ki try kejeye ga.

regards,

[My Heaven]

Pahly ka asan hal ya ha k

1. Adjacent cell ya jahan aap result chahte hain wahan p
2. =CONCATENATE( " lekhain"
3. phir is k bad TRANSPOSE( ka function start karain. aur apne pore data ki range lain.
tu formula kuch yon ho ga

=CONCATENATE(TRANSPOSE('yourrange'))

4. Enter krne sa pahly Transpose k pore function ko Mouse se select Karain aur F9 press karain. aap notice karainge k transpose k function ki jaga aap ko result nazar aai ga. aur us k gird {} brackets honge. aap in Bracket ko delete kar dain. aur enter Press karian. Aap ka Join krne ka masla hal ho jae ga.
But remember k ya as text cell m store ho ga.

Jahan tak aap k comma ka masla ha, us m masla ya ha k aik cell m kiten length aai gi mjy andaza nahee ha. k excel ka aik cell itna lamba digit support kare ga.

Pahly ise try karain phr dosra masla solve krne ki try kejeye ga.

regards,

syar bhai you are great yar
"34254645756","34344356",46345573457"
is tarha ho gya hai
but ab ek aur problem hai wo ye k jab in k ("") khatm krta hun to aese ho jata hai
3.00041651603E+218

yani cell k range se upar hai digits.
plz is k bare me bata den

[My Heaven]

Pahly ka asan hal ya ha k

1. Adjacent cell ya jahan aap result chahte hain wahan p
2. =CONCATENATE( " lekhain"
3. phir is k bad TRANSPOSE( ka function start karain. aur apne pore data ki range lain.
tu formula kuch yon ho ga

=CONCATENATE(TRANSPOSE('yourrange'))

4. Enter krne sa pahly Transpose k pore function ko Mouse se select Karain aur F9 press karain. aap notice karainge k transpose k function ki jaga aap ko result nazar aai ga. aur us k gird {} brackets honge. aap in Bracket ko delete kar dain. aur enter Press karian. Aap ka Join krne ka masla hal ho jae ga.
But remember k ya as text cell m store ho ga.

Jahan tak aap k comma ka masla ha, us m masla ya ha k aik cell m kiten length aai gi mjy andaza nahee ha. k excel ka aik cell itna lamba digit support kare ga.

Pahly ise try karain phr dosra masla solve krne ki try kejeye ga.

regards,

syar bhai bus ho gya
me ne pehle (,) ko ( ; ) k sath replace all kya phir (") khatam kr diye
you are really a great person yaaaaaar. thankx alllllllllllooooooooooooooot ap ne mjhe itni mehnat se bachaya.
3 din se lagatar manually tareeky se itni mehnat kar kar k mera bera gharak ho gya tha.
bohot bohot shukriya yar.
zindgi me agr kbhi meri zaroorat pare to hukam karna jaaaan bhi hazir hai.

[My Heaven]

acha bhai agr inko dobara in shape me lana ho to ?
for example
98097423
79803450
76783487
59873452
76098734
57690876
98324789