Thread: splitting a number into two cells from one
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph David Biddulph is offline
external usenet poster
  
Posts: 618
Default splitting a number into two cells from one
"jglen" wrote in message
...
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?

=LEFT(A1,3) in B1
=RIGHT(A1,6) in C1

Another option is Data/ Text to Columns, & choose fixed width accordingly
--
David Biddulph


Reply With QuoteReply With Quote