Execel and Regular Expressions

I have an excel spreadsheet in which the first column of every row contains a 8 digit number. I would like to somehow auto-populate the last column of each row with the first digit of the number in the first column in that row. Is this possible, if so, how? I was thinking of regular expressions, but I don’t know if those are applicable in Excel.