I have a column in an Excel Sheet with the following cell information;

3.1.2.4

3.2.1.4.5

3.3.5.5

3.4.4.4

3.5.6.8.1

3.6.5.6.2.

3.7.2

3.7.3.1

3.7.6.2

I am trying to find the most efficient global formula to return the following results.

If 1st 2 characters equals 3.1 then return value "A"

If 1st 2 characters contains 3.2 then return value "B"

If 1st 2 characters contains 3.3 then return value "C"

If 1st 2 characters contains 3.4 then return value "D"

If 1st 2 characters contains 3.5 then return value "E"

If 1st 2 characters contains 3.6 then return value "F"

If 1st 2 characters contains 3.7 then return value "G"

Thank you all!