reading partial cell

[Wiley1]

This is my data:

802208 aecl
802208 W
802330 aecl
802330 W
802474 aecl
802474 W


for every a in the second column, I need 001 in a separate column.
for every e in the second column, I need 013 in a separate column.
for every c in the second column, I need 005 in a separate column.
for every l in the second column, I need 015 in a separate column.
for every w in the second column, I need 003 in a separate column.

I don't know how to tell Excel to look for and pick out a single letter in a cell.
I tried this =IF(N2="a","001") but that only seems to take the entire cell into account.

Also, I would like to add a suffix to the end of the first column based on the letters in the second column. This can be a separate task.

802208 aecl
802208 W
802330 aecl
802330 W
802474 aecl
802474 W

If the second column has an a in it, I would like the first column to read 8022081.
If the second column has an e in it, I would like the first column to read 802208C.
If the second column has an l in it, I would like the first column to read 80220815.
.
.
.

Please help

[Pepe Le Mokko]

To check contents of a cell try

=IF(ISNUMBER(SEARCH("a",A1)),do_sthg, do_sthg_else)

. If your search will be case sensitive use the fIND function

[Wiley1]

Pepe, Thank you for the reply. I think I maybe should haev entered thsi in the new user forum. I did not understand your reply and could not get it to work. Could you explain a little clearer for a very novice user?

[Marcol]

Your request isn't to clear, see if this workbook helps

[EDIT]
Forgot to sort the lookup arrays.
Attachment now corrected.

[Lemice]

Hello

What Pepe meant on using
=IF(ISNUMBER(SEARCH("a",A1)),do_sthg, do_sthg_else)
is something like

=IF(ISNUMBER(SEARCH("a",A1)),"001", "")

SEARCH function will lookup for the text within a text, and return the number of letter in which the text is found, for e.g. SEARCH "a" in "abcd" returns 1, "a" in "dcba" returns 4, and "a" in bcd returns #VALUE! (not found).
Basing on that idea, Pepe put a ISNUMBER trap in front of it, testing whether SEARCH returns a number (Text is found) or not (Text is not found).
Everything else is just function of IF. You can read it like this: IF(Find "a" in text, what to do if it's found, what to do if it's not found).

[Pepe Le Mokko]

I must admit a was lazy when answering . Thanks to Lemice for explaining