Splitting cell information into two cells

[Todd]

I have a number in cell A1 that reads 12345678. I need a
formula that will take the first 3 of that number and put
them in cell B1 and the last 5 into cell C1. Anyone have
any idea what formula to use for this?

Thanks in advance.
Todd

 

[Naraine]

in bi mid(a1,1,3)

in c1 mid(a1,4,len(a1))

 

[Mark Graesser]

Todd
Text functions should work for you

=LEFT(A1,3
=RIGHT(A1,5

If your number has decimal places or leading zeros which aren't displayed, you could use

=LEFT(TEXT(A1,"00000000"),3
=RIGHT(TEXT(A1,"00000000"),5


Good Luck
Mark Graesse
(e-mail address removed)

----- Todd wrote: ----

I have a number in cell A1 that reads 12345678. I need a
formula that will take the first 3 of that number and put
them in cell B1 and the last 5 into cell C1. Anyone have
any idea what formula to use for this

Thanks in advance
Tod