Formula Needed Please

Hi all
Can anyone help me with this please ?
In ROW A1 I have the following: 200,400 - this is from a drop down list.
What i need to do is then split the two numbers so as the 200 apperars in ROW B1 amp; the 400 apperars in ROW C1
This is so i can then do a simple calculation to the separate numbers
Please could you give me the formula i need to get the 200 in row B1 then i can try and work out the C1 formula !!
Thanks

If it's always 2 sets of 3 digit numbers you could use

In B1  =Left(A1,3)
In C1  =Right(A1,3)

Jim

Hi Jim
It will not always be 3 digit numbers, sorry i should have said
Im confused ha ha

providing A1 is a text value, otherwise Excel will force it to a number you can use the following

B1 :- =LEFT(A1,FIND(",",A1)-1)

C1 :- =RIGHT(A1,LEN(A1)-FIND(",",A1))

Hi Jim, you might want to coerce the result as calcs are to be performed on the split, so

B1:= --LEFT(A1,3)
C1 = --RIGHT(A1,3)

EDIT: too slow... andrew what are the range of the values in A1 -- ie does it > 1,000,000 ?

Hi
The highest number is 100,000
If i wanted to put the numbers out of the way in rows such as AA amp; AB is this poss as i am only using them for a calculation in a row i need to view !!
Sorry to be a pain in d *** ha ha

Sorry should have also asked -- what is the min value -- ie what is the range of values that A1 can be ?  1,000 to 100,000 or 1 to 100,000 ... if A1
Would the below work for you assuming value in A1 ?

AA1: =FLOOR(N28,1000)/1000
AB1: =MOD(N28,1000)

Hi
The lowest value is 1 the highest value is 100,000
Does this help ?
Jesus your all like formula wizards how do you no all this stuff !!

Not sure if your last post implied we solved your problem or not ?