Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Splitting cell information into two cells
0 views
Skip to first unread message
Todd
Dec 19, 2003, 3:53:51 PM12/19/03
to
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?
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
Dec 19, 2003, 4:12:26 PM12/19/03
to
in bi mid(a1,1,3)
in c1 mid(a1,4,len(a1))
"Todd" <to...@alliedhomenet.com> wrote in message
news:037a01c3c672$34effba0$a101...@phx.gbl...
Mark Graesser
Dec 19, 2003, 4:16:13 PM12/19/03
to
Todd,
Text functions should work for you.
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 Graesser
mark_g...@yahoo.com
----- Todd wrote: -----
0 new messages