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.