Left Function
in [General]
|
From: AJ on 20 Apr 2010 12:49 I am trying to pull certain characters based on a criteria for the third position character. In Column A, I could have a code such as BB11 or a Code such as BMR2. If the third position character is a number then I only want to pull the first 2 digits BB but if the third position character is a letter, then I would like to pull the first 3 characters BMR. Can anyone help? -- AJ
From: Mike H on 20 Apr 2010 13:01 Try this =LEFT(A1,3-(ISNUMBER(MID(A1,3,1)+0))) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "AJ" wrote: > I am trying to pull certain characters based on a criteria for the third > position character. > > In Column A, I could have a code such as BB11 or a Code such as BMR2. If > the third position character is a number then I only want to pull the first 2 > digits BB but if the third position character is a letter, then I would like > to pull the first 3 characters BMR. > > Can anyone help? > > > -- > AJ
|
Pages: 1 Prev: Excell 2007 will not open XLSX Next: Excel - Run Macro on Cell Change |