Posted on 2011-09-09
Hello all, I am tyring to extract a weather observation. I need to get the temperature for a weather reports. The example below is in cell A1. I need to get the value 23 into cell c34. Some things that are constant in a weather observation it is always preceded by the first "/" there can be mulitple "/" but the temperature is always before the first "/" also the value can be either two digits or a "M"followed by 2 digits, like M12, which is equal to minus 12. How can i get a way to extract this data.
KICT 092253Z 02006KT 10SM TS BKN075CB OVC110 23/15 A3001