Tristan has attended:
Excel Intermediate course
Excel Advanced course
Singling out characters
how would i single out an individual character in a record? For example: ASUM2412 Iwould like to single out the 'm' and create a record called monthly?
RE: 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'