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 !!
If it's always 2 sets of 3 digit numbers you could use
In B1 =Left(A1,3)
In C1 =Right(A1,3)
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
C1 = --RIGHT(A1,3)
EDIT: too slow... andrew what are the range of the values in A1 -- ie does it > 1,000,000 ?
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 ?
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 ?