Cell D4 has the following in it: (1-3, 5.58)

I want to get the 5.58 in cell K16. Is there a way to have excel do this? I
know I can use the text to columns command to seperate the 5.58 and then use
= (whatever cell it is in). I will be updating this everyday though and
would like to not have to use the text to columns. Any ideas? Thanks

=VALUE(MID(D4,FIND(",",D4)+1,FIND(")",D4)-FIND(",",D4)-1))

"Jambruins" wrote in message
...
Cell D4 has the following in it: (1-3, 5.58)

I want to get the 5.58 in cell K16. Is there a way to have excel do this?
I
know I can use the text to columns command to seperate the 5.58 and then
use
= (whatever cell it is in). I will be updating this everyday though and
would like to not have to use the text to columns. Any ideas? Thanks

Try
=RIGHT(K2,4)

"Jambruins" wrote in message
...
Cell D4 has the following in it: (1-3, 5.58)

I want to get the 5.58 in cell K16. Is there a way to have excel do this?
I
know I can use the text to columns command to seperate the 5.58 and then
use
= (whatever cell it is in). I will be updating this everyday though and
would like to not have to use the text to columns. Any ideas? Thanks

Sorry meant
=RIGHT(K16,4)
"daiblackburn" <daiblackburn@workforachange wrote in message
...
Try
=RIGHT(K2,4)

"Jambruins" wrote in message
...
Cell D4 has the following in it: (1-3, 5.58)

I want to get the 5.58 in cell K16. Is there a way to have excel do
this?
I
know I can use the text to columns command to seperate the 5.58 and then
use
= (whatever cell it is in). I will be updating this everyday though and
would like to not have to use the text to columns. Any ideas? Thanks

I think you mean
Select Cell K16 and in there type formula =RIGHT(D4,4)

"daiblackburn" <daiblackburn@workforachange wrote in message
...
Sorry meant
=RIGHT(K16,4)
"daiblackburn" <daiblackburn@workforachange wrote in message
...
Try
=RIGHT(K2,4)

"Jambruins" wrote in message
...
Cell D4 has the following in it: (1-3, 5.58)

I want to get the 5.58 in cell K16. Is there a way to have excel do
this?
I
know I can use the text to columns command to seperate the 5.58 and
then
use
= (whatever cell it is in). I will be updating this everyday though
and
would like to not have to use the text to columns. Any ideas? Thanks