Singling out characters

If the code is always the same number of characters and the character you want is always in the same place then you could try using the left and right formulas. For your example: =LEFT(G5,4) where G5 is "ASUM2412" which gives you "ASUM" and then in another column: =RIGHT(F5,1) where F5 is the result of the first formula. This gives you 'M'