Pulling out letters

What do you mean by "pull out" and what do you want to do with the other letter when found?

Making it clearer

In one column I have several letters standing for different things. They are in no certain order. I have a formula to do for each letter. These letters are for different types of insurance. Each one is calculated differently. For example in (I3). There is an LMDF
L=life, M=Medical, D=Dental, and F=family. I guess what I am asking is there a way to have excel look at the L and then do the calculation for that and then go to the M or will I need to seperate these into different columns?

Sorry for not being clearer..

Re: Making it clearer

Still not entirely sure I understand, but perhaps either the FIND or SEARCH worksheet functions wiil do what you need. For example :-
=IF(ISERROR(SEARCH("L",I3,1)),"Not Found","Found")

Re: Making it clearer

This is what I am trying to accomplish. The codes are in cell (I3).

I am not sure if a table would be beneficial

The Insurance Code indicates which coverages are taken by the employee; L=Life, M=Medical, D=Dental; E=Employee, F=Family (Codes ordered as listed here). For example an employee enrolled in the Life Insurance and Dental Insurance programs for his family would have a code of LDF. Example 2, an employee enrolled in the Medical Insurance and Dental Insurance programs for himself would have a code of MDE.

Life Insurance @ $2.10 per $1000 of coverage. Each salaried employee is covered for 2.5 times his annual salary. company pays 80%, employee pays 20%.

Medical Insurance offered for the employee ($172.00/month) or the employee and his family ($287.00/month). company pays 75%, employee pays 25%.

Dental Insurance offered for the employee ($22.50/month) or the employee and his family ($45.47/month). company pays 90%, employee pays 10%.

Still not entirely sure I understand, but perhaps either the FIND or SEARCH worksheet functions wiil do what you need. For example :-

Re: Making it clearer

How is your sheet set up?
That is :
- what data (e.g. annual salary) are in what columns, and
- based on the codes in column I, what info (& in what columns) do you want to produce ?

Sheet Setup

My annual salary is in N3. My adjusted gross for the federal annual - dependents are in P3. I couldn't figure a way to get the formula to first do the allowance for the dependents and then do the federal. My salaried employees are based on a number at the end of a SSN (A3). So I use the right() to get that. I hope this helps.

Sorry, don't understand - am not from U.S.