Thread: splitting a number into two cells from one
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jglen jglen is offline
external usenet poster
  
Posts: 2
Default splitting a number into two cells from one
I would like to know how to split ie 123456789 in cell A1 to 123 in B1, and
456789 in C1. Is there a formula that can do this for me?
Reply With QuoteReply With Quote