Converting Each Column cell Mobile Number to in one cell separated by semi colon.

[aligahk06]

Dear All,

I have a excel sheet containing mobile number from A3:A4500. I want to each mobile number separated by ; in one cell B3.
ex: 9856231212;586452124;....... and so on ...


Rgds,

Aligahk06

 

[My Aswer Is This]

That would result in 49,500 characters in one cell which exceeds Excels limit for characters per cell.

 

[aligahk06]

That would result in 49,500 characters in one cell which exceeds Excels limit for characters per cell.

What would be solution for this kind of problem.