Excel 2007 : Add text from multiple cells and delete from one cell

[jimbean1234]

Hi

I would like someone to help me with a formula to combine multiple text values from cells in a row like.
AB, AM, AZ, BB, BY

and also to remove text value found in FL (same row) and output the total value into FZ.

ALL THESE VALUES ARE A PART OF SINGLE ROW

so basically FZ= (AB + AM + AZ + BB + BY) -FL

I have tried the concentrate fn, but some values are separated with comma, so the output combines some values from multiple cells into one incomprehensible word

Sample Workbook Attached:
Final Value in M should be A+E+G+I and subtract K from total
So M should look like First, Second, Fourth, Fifth, Nine, Eleven, Thirteen, Seventeen
Many thanks for this...

[davesexcel]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[jimbean1234]

Thank you, I attached sample workbook.