Entering 5 digit number, where each digit creates a specific result based on a list.

Hello, I consider myself to be pretty good with Excel but with this latest task, I don’t know where to begin. I am trying to create a little formula that will decode the Marine MAYFOR weather report so it can be read like a sentence instead of having to constantly translate it one number at a time … you can see the MAYFOR below

http://www.weatheroffice.gc.ca/forec...in=fqcn30.cwto

Basically the report comes in a series of numbers such as “11600.” The first number never changes, but the following 4 numbers are variable and each tells you something different. In my example the second digit is a one (1) which means that the report is “valid for 3 hours” … the second digit could also reflect …

2nd Digit can be …
0 = Beginning of Period
1 = Valid for 3 Hours
2 = Valid for 6 Hours
3 = Valid for 9 Hours
4 = Valid for 12 Hours
5 = Valid for 18 Hours
6 = Valid for 24 Hours
7 = Valid for 48 Hours
8 = Valid for 72 Hours
9 = Occasionally

3rd Digit can be …
0 = Winds Calm
1 = Winds NE
2 = Winds E
3 = Winds SE
4 = Winds S
5 = Winds SW
6 = Winds W
7 = Winds NW
8 = Winds N
9 = Winds Variable

4th Digit can be …
0 = 0 – 10 knots
1 = 11 - 15 knots
2 = 16 - 20 knots
3 = 21 - 26 knots
4 = 27 – 33 knots
5 = 34 – 40 knots
6 = 41 – 47 knots
7 = 48 – 55 knots
8 = 56 – 63 knots
9 = Greater than 64 knots

5th Digit can be
0 = Moderate to good visibility (greater than 5km)
1 = Risk of accumulation of ice on superstructures
2 = Strong risk of accumulation of ice on superstructure
3 = Mist (visibility 1 - 5km)
4 = Fog (visibility less than 1km)
5 = Drizzle
6 = Rain
7 = Snow, or rain and snow
8 = Squally weather with or without showers
9 = Thunderstorms

So if you are still with me, basically I want to be able to enter the Code “11600” for example in cell A1 then magically have “Valid for 3 Hours” in cell B1, “Winds W” in cell C1, “0 – 10 knots” in cell D1 and finally “Moderate to good visibility (greater than 5km)” in cell E1 so the whole weather report reads like a sentence.

It would be nice if I could enter a series of these MAYFOR codes in the "A" column and have their meanings automatically propigate in the adjacent B,C,D and E cells ... any ideas?

Pretty easy in Excel.