splitting a number into two cells from one

J

jglen

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?
 
C

CWillis

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

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

-chris
 
M

Marcelo

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:
 
S

Sloth

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"
 
D

David Biddulph

jglen said:
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?
Click to expand...

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

Another option is Data/ Text to Columns, & choose fixed width accordingly
 
Top