ending number

[albertldee]

hi everyone i just receive a spread sheet to seperate number
cell D has number like this 245-15 or 247/587-8
is there a formula that would let me seperate the number that come after - to cell C
example cell D4 has 256-16 i want to add the any number after the - like 16 into cell C4

thanks

 

[Oaktree]

=RIGHT(D4,LEN(D4)-SEARCH("-",D4))+0

 

[Greg Truby]

<ul>[*]=RIGHT(D4,LEN(D4)-FIND("-",D4))[/list]{Edit}(a)Too slow on the draw! Hiya Oaktree. (b)Oak's use of the "+0" at the end results in the cell's results being a number whereas my formula results in the output being treated as text. Use whichever fits your needs.{/edit}

 

[Aladin Akyurek]

hi everyone i just receive a spread sheet to seperate number
cell D has number like this 245-15 or 247/587-8
is there a formula that would let me seperate the number that come after - to cell C
example cell D4 has 256-16 i want to add the any number after the - like 16 into cell C4

thanks

=REPLACE(D4,1,SEARCH("-",D4),"")+0