Splitting cell information into two cells

  • Thread starter Thread starter Todd
  • Start date Start date
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
 
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
 
Back
Top