splitting a number into two cells from one

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
in b1: =LEFT(A1,3)
in C1: =RIGHT(A1,6)

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

-chris
 
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:
 
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"
 
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
 
Back
Top