I have a excel file that pulls canola future data from a web link. This info is then used to doing calculations in a formula. Problem is that when the market closes then that value automatically gets a (S) add to show that the markets are closed. Once the (S) is added it will not all formula to calculate due to the number letter combination. Is there away to force the formula to work with the linked cell having both numbers and letters.
Deduction | Farmers Target | Futures-Dedctions=Net | Price to Farmer | |||||
Bases | Freight | Comission | $/Bushel | Futures | $/MT | $/Bushel | $/MT | |
35 | 23 | 2.5 | 16 | 683.70s | #VALUE! | #VALUE! | 714.972 | #VALUE! |