Thread: splitting a number into two cells from one
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
CWillis CWillis is offline
external usenet poster
  
Posts: 36
Default splitting a number into two cells from one
in b1: =LEFT(A1,3)
in C1: =RIGHT(A1,6)

there is also a mid( ) function you may want to use...

-chris

"jglen" wrote:

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