Can I do this?
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 |
All times are GMT +1. The time now is 11:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com