Splitting cell information into two cells

T

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
 
M

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
[email protected]

----- 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
 
Top