Hello all, I am tyring to extract a weather observation. I need to get the pressure for a weather reports. The example below is in cell A1. I need to get the value 3001 into cell c34. Some things that are constant in a weather observation it is always follows the letter A and then four digits How can i get a way to extract this data.
KICA 092253Z 02006KT 10SM TS BKN075CB OVC110 23/15 A3001