Hello

I have exported data from a database into a comma separate file and imported the data into a Excel spreadsheet successfully.
But I run into a problem when i want to extract a letter from a text string in Excel. The string is mixed text and numbers, but there is always only one letter. Here is an example of what I would like to do.
In Cell A1 the value is "E-10" i want it to return a "E" in Cell B1
In Cell A2 the value is "A12" I want it to return a "A" in Cell B2
In Cell A3 the value is "09C" I want it to return a "C" in Cell B3
In Cell A4 the value is "g" I want it to return a "g" in cell B4
In Cell A5 the value is "11-S" i Want it to return a "S" in Cell B5
and so on
If the string always had the same order, then i could use Left, Right or MID formula, but I don't know how to deal with the problem when all the values are not in the same order.
Hope you can see what I mean.
Any help would be appreciated
Thanks