If cell contains A, write X - or - if cell contains B, write Y

[Evan_Dobos]

Hey guys,

I have hundreds of records that contain one of 12 combinations of initials. I want to create a new column that finds those initials and depending on what they are, write the entire name.

For example:
Column A includes:

2017-02-07.boe_.ag_.pdf
2017-02-07.bos_.ag_.pdf
2017-02-09.bof_.ag_.pdf

I want the formula for Column B to find the initials, and write in the full name following these rules:

• if it finds “boe”, write “Board of Education”
• if it finds “bos”, write “Board of Selectmen”
• if it finds “bof”, write “Board of Finance”

So, the end result in Column B would be:

Board of Education
Board of Selectmen
Board of Finance

Thanks for any and all help with this!

If cell contains A, write X - or - if cell contains B, write Y

[Justin_Barrett]

Could you please provide more detail on the setup of the debit/credit formula, and how exactly you’d like the output to look when merging that output with the category formula?