G Guest Jul 6, 2006 #1 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?
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?
G Guest Jul 6, 2006 #2 in b1: =LEFT(A1,3) in C1: =RIGHT(A1,6) there is also a mid( ) function you may want to use... -chris
G Guest Jul 6, 2006 #3 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:
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:
G Guest Jul 6, 2006 #4 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"
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"
D David Biddulph Jul 6, 2006 #5 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
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
