Specific Character in a cell

Posted by Jason on March 05, 2001 2:38 PM

I am trying to create an if statement that refers to a specific character within a cell. An example would be that if my cell had 353ABA in it I would like to create a formula that would act only on the last A in the string or the 6th character. I know that I can put each character into a seperate column, however I would like to keep it all in one cell.

Posted by David Hawley on March 05, 2001 2:51 PM

Hi Jason

If you are always checking the 6th character then you can use =IF(LEFT(A1,6)="A",YourFormula

Dave
OzGrid Business Applications

Posted by Aladin Akyurek on March 05, 2001 2:54 PM

How about

=IF(MID(cell,6,1)="A",then-action,else-action)

Aladin

Posted by Jason on March 06, 2001 6:57 AM

Thanks Guys. It worked Great!!