Split data between 2 cell from 1 cell

[Uzzal]

Hi I've got data in i cell as 110862140088150 100862140430020
Now I need to separate it in two different cells as 110862140088150 & 100862140430020
How to that ?

 

[Somendra Misra]

Hi Uzzal,

Use Text to column and give deliminator as Space.

Regards,

 

[NARAYANK991]

Hi Uzzal ,

When you do a Text to Columns , as suggested by Misra , select the Data Format for each column as Text before clicking on Finish ; this ensures that the data is displayed correctly.

Narayan

 

[Uzzal]

Thanks for always been there to support

 

[Abhishekbasti]

Hi Naryank,
Nice suggestion , but i have a concern . suppose if we have to numbers like in cell A1 1108621811and in cell A2 1008621 . I want to multiply both numbers in Cell A3 . Correct output is 1118179239632631 if i use calculator , if i do it with excel i get incorrect output :1118179239632630. so is there any way of getting correct output using vba code or excel formula.

Thanks in advance

 

[Somendra Misra]

Hi Abhishek,

Excel can handle numbers upto 15 digits only any thing above that will be turned to 0. So you are getting the result of 16 numbers and last 1 is getting converted to 0.

See below links to get UDF for achieving the same.

http://www.tushar-mehta.com/misc_tutorials/project_euler/LargeNumberArithmetic.htm

Regards,

 

[NARAYANK991]

Hi Abhishek ,

One more link :

http://www.excel-ticker.com/calculation-of-very-large-numbers-in-excel-part-5-add-in/

Narayan

 

[Abhishekbasti]

Thanks, Narayan,Somendra for sharing link
I appreciate it.