Need a formula that looks at the first digit or letter in a cell
Solution 1:
Using a combination of the Left and If functions...
=IF(LEFT(A1,1) = "8", 2, 1)
That's assuming you want to number returned as a number... if you want it as a string..
=IF(LEFT(A1,1) = "8", "2", "1")