splitting a number into two cells from one

[Guest]

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?

 

[Guest]

in b1: =LEFT(A1,3)
in C1: =RIGHT(A1,6)

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

-chris

 

[Guest]

Hi JGlen,

if will always the first 3 numbers on the b column and the rest on the C

use:

B column
=left(a2,3)

C Colum
=right(a2,(len(a2)-len(b2))

hth
regards from Brazil
Marcelo

"jglen" escreveu:

 

[Guest]

There are two methods you can use.

1. Use the following formulas
=LEFT(A1,3)
=RIGHT(A1,6)

2. Use Data Text to columns and select "Fixed Width"

 

[David Biddulph]

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