Thread: How do I divide a cell into two cells?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default How do I divide a cell into two cells?
You could use Data | Text to Columns
OR
Suppose A1 holds a 9 digit number such as 123456789, then in B1
=INT(A1/10000) gets you 12345 while =A1-B1*10000 returns 6789.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"RobBB&B" wrote in message
...
I am looking to divide the items in a cell into to two new cells with one
having the first five digits and the second cell to have the balance


Reply With QuoteReply With Quote