Extracting Characters from Cell

[andreascostas]

Hi
In column c I have a number of equations such as 2x + 20 . I need to pull out the 20 into another adjacent cell.
I used: =right(c1,len(c1)-Find(" + ",c1)) and it gives me the 20 .
The problem is that some of the equations have a negative in them ex. 4x - 19 or 2x - 6...and the formula above won't
work because it is looking for " +".....is there a way to get it to works with both at the same time???
Thanks

 

[Rick Rothstein]

Hi
In column c I have a number of equations such as 2x + 20 . I need to pull out the 20 into another adjacent cell.
I used: =right(c1,len(c1)-Find(" + ",c1)) and it gives me the 20 .
The problem is that some of the equations have a negative in them ex. 4x - 19 or 2x - 6...and the formula above won't
work because it is looking for " +".....is there a way to get it to works with both at the same time???

If there is always a space in front of that last number, you could use this formula...

=TRIM(RIGHT(SUBSTITUTE(C1," ",REPT(" ",99)),99))

Otherwise, try this...

=TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(C1,"-","+"),"+",REPT(" ",99)),99))

 

[andreascostas]

Ok. Question. The first formula works with numbers I have in cell c1......when I try it to do the same thing
with numbers in b1 it does not work. ????? what does the 99 do in the formula/

 

[andreascostas]

Never mind....I got it to work with B1 also...thanks for all your help.